nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Converting time to time intervals and resetting based on second column values to prevent x-axis offset

polymerist

I have a data table with the columns "Time" (Numeric, continuous, formatted in 12-hr h:m:s) and "Name" (Character, just a list of the experiment to which each time point is associated). When I graph using other columns not mentioned here as the Y-axis, and Time as the x-axis, the issue arises where each plot between x-grouping variables is shifted since the x-axis scale remains the same between x-grouping variables (Figure 1).

x vs y.png

Figure 1. Each x-grouping variable is a "Name" column variable with "Name also as the Overlay.

My thought is to write a script to:

1. Create a new column

2. Code new column with a formula that converts the "Time" column to time in seconds, starting at "0" and counting up with a specified interval (2 seconds in this case), resetting to 0 as soon as the "Name" column changes values.

My main questions are:

1. Is this possible?

2. Is there an easier way to do this without making a new column?

Currently on JMP 17.2.0 on Windows 10.

Thanks!

Accepted answers

polymerist

Okay, nevermind, the code I posted actually worked! I had my column name misspelled :confounded_face:

Only remaining question then would be, is there an easier way to do this without making a new column?

All comments

mmarchandFSLR

See if this does what you need.

dt << New Column( "ElapsedTime", numeric, continuous, Formula( :LocalTime - Col Min( :Local Time, :Name ) ) );

polymerist

Thanks for the reply!

Unfortunately, that returns the column "Elapsed Time" seen in the figure below.

I tried the following code, which yielded the column, "Time (s)" in the figure above as well. Seems like it's doing the set inititial to zero function, but not converting anything else.

Names Default To Here(1);  // Ensure scope is local for column references
dt = Current Data Table(); // Reference to the active data table

// Add a new numeric column "Time (s)" with the specified formula
dt << New Column( "Time (s)",
    Numeric, Continuous, Format( "Best", 12 ),  // numeric format (optional)
    Formula(
        If(
            Row() == 1,
            // Case 1: First row of the table -> start at 0 seconds
            0,
            :Name("Name") != Lag( :Name("Name") ),
            // Case 2: Identifier changed from the previous row -> new run, reset time to 0
            0,
            // Case 3: Otherwise (same run as previous row) -> accumulate time difference
            Lag( :Name("Time (s)") ) + ( :LocalTime - Lag( :LocalTime ) )
        )
    )
);

mmarchandFSLR

There may be something unexpected about your :LocalTime column. I tried my formula on a made-up table, and it worked as intended. How is your :LocalTime column formatted?

txnelson

I created an example data table

And then I ran the following JSL

Names Default To Here(1);  // Ensure scope is local for column references
dt = Current Data Table(); // Reference to the active data table

// Add a new numeric column "Time (s)" with the specified formula
dt << New Column( "Time (s)",
    Numeric, Continuous, Format( "Best", 12 ),  // numeric format (optional)
    Formula(
        If(
            Row() == 1,
            // Case 1: First row of the table -> start at 0 seconds
            0,
            :Name("Name") != Lag( :Name("Name") ),
            // Case 2: Identifier changed from the previous row -> new run, reset time to 0
            0,
            // Case 3: Otherwise (same run as previous row) -> accumulate time difference
            Lag( :Name("Time (s)") ) + ( :LocalTime - Lag( :LocalTime ) )
        )
    )
)
dt << New Column( "ElapsedTime", numeric, continuous, Formula( :LocalTime - Col Min( :Local Time, :Name ) ) );

An got the following output

polymerist

Okay, nevermind, the code I posted actually worked! I had my column name misspelled :confounded_face:

Only remaining question then would be, is there an easier way to do this without making a new column?

mmarchandFSLR

It requires a new column. It doesn't have to be a persistent column, meaning it could be a column that exists only while the graph is there.

Graph Builder(
	Transform Column(
		"Time (s)",
		Formula( :LocalTime - Col Min( :LocalTime, :Name ) )
	),
	Show Control Panel( 0 ),
	Variables( X( :"Time (s)"n ), Y( :Y Column ), Group X( :Name ) ),
	Elements( Smoother( X, Y, Legend( 8 ) ) )
);

txnelson

You can always use a Transform (virtual) column when you run your Graph Builder. That way you do not have to have an actual column in your data table.