topic Re: Adding Secondary Time Scale in Discussions

Adding Secondary Time Scale

Nalrus — Wed, 16 Apr 2025 20:39:21 GMT

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!

Re: Adding Secondary Time Scale

Thierry_S — Wed, 16 Apr 2025 21:19:58 GMT

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,

Re: Adding Secondary Time Scale

Thierry_S — Wed, 16 Apr 2025 21:29:41 GMT

Sorry,

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

Best,

Re: Adding Secondary Time Scale

mmarchandFSLR — Wed, 16 Apr 2025 21:54:14 GMT

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

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

Re: Adding Secondary Time Scale

Nalrus — Wed, 16 Apr 2025 22:18:36 GMT

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.

Re: Adding Secondary Time Scale

Nalrus — Wed, 16 Apr 2025 22:23:40 GMT

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

Re: Adding Secondary Time Scale

jthi — Thu, 17 Apr 2025 05:17:22 GMT

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)

Re: Adding Secondary Time Scale

mmarchandFSLR — Thu, 17 Apr 2025 11:45:35 GMT

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 )

Re: Adding Secondary Time Scale

Nalrus — Thu, 17 Apr 2025 15:58:02 GMT

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