Adding Secondary Time Scale

[#1]

Hello,

I'm looking for an elegant way of creating a "Cycle Time" column, that will start at 00:00:00 every time that the Cycle Count changes (see the example file). The time should be calculated from the original Date and Time columns. The intention is to graphically overlap Cycles related Outputs. Thanks in advance for any ideas!

[#2]

Hi, 

Would something like the formula below meet your requirements (as the Loop Time formula)?

If( Row() == 1 | :Cycle != Lag( :Cycle, -1 ),
	0,
	Lag( :Loop Time ) + Date Difference( :Time, Lag( :Time, -1 ), "second" )
)

Best,

TS

[#3]

Sorry,

I was too hasty. The above Formula has some issues.

Best,

TS

[#4 · Accepted solution]

This formula works pretty well.  Set the display format to ":day:hr:m:s"

:Date + :Time - Col Min( :Date + :Time, :Cycle )

[#5]

Thanks for looking into it! Almost done! The formula works and creates the continue secondary time. But it aslo needs to reset to 00:00:00 every time when the cycle number changes. 

[#6]

Found the issue. You are right, just to replace Cycle to Loop and it works. Awsome!

[#7]

To make sure it separates out the Loop within each Cycle, use both as by columns.  Otherwise, Loop 1 in Cycle 2 will continue from Loop 1 in Cycle 1, for example.

(:Date + :Time) - Col Min( :Date + :Time, :Cycle, :Loop )

[#8]

This goes outside of the topic, but it might also be worth it to combine date and time into single timestamp column. In JMP you can do this by just adding those columns together and then changing the format

Before changing the format the timestamp can look weird (number of seconds since January 1, 1904)

Format changed to y/m/d h:m:s

This will basically provide you with plenty of different formatting options and quick formulas from right click menu from the single column

You can also use timestamp column for example in graph builder and if you wish to see data on day level, you can use date/time bin on the axis (right click on the axis)

[#9]

Thank you, Jarmo! I will try playing with it.