Perfect. Exactly what I was looking for. ... View more

The macro below isn't particularly elegant, but will do the job.    For ( i= 100, i <= N Rows ( dt ), i++, dt << Select Rows (Index (i-99, i)); dt << Subset( Selected Rows( 1 ), Selected Columns ( 0 ), Output Table ("out") ); Current Data Table ( Data Table ("out")); x = Col Minimum ( :YourDataColumn ); Close ( Data Table ( "out"), no save); Column ( "YourMovingWindow" )[i] = x; ) Sub-setting the selected data, the way I've done it, is slow. Perhaps another user has a better idea how to access the selected data and extract the desired product. I also wonder how a column formula could look like to achieve the results without a macro.   Cheers, Kofi ... View more

This also answers my other question why h:m:s on the x-axis is 00:00:00 on the graph of the builder (and not on the legacy graph). Because its not a label, but a true point in time, in this case midnight of the respective days. Thanks. I really appreciate the explanation. ... View more

Hi Mark,   that's a good one. Turned out the data table had 1 day entered twice = double entries.   Still remains the question why one platform picks up the duplicates and the other doesn't...? I'm using v15.1.0 ... View more

I rather suspect there's something wrong with the Control Chart Builder.  When I try to create a IR chart through the Control Chart Builder, JMP tells me that at least 1 sample has sample size > 1, hence can't create IR, has to make XBar (and consequently doesn't allow me to change back to individual and moving range) When I try to create a XBar chart through the Legacy Control Chart menu, JMP tells me that no sample has sample size > 1, hence it can't create XBar, has to make IR. What now? Does any of my sample has sample size >1 or not? Control Chart Builder platform says yes, Legacy Control chart platform says no. That's a bug! Simple as that. My guess: Control Chart Builder can't read it's own date-time format. Sets all h:min:s behind the date to 00:00:00 and then, yes, plenty of observations at the same time (=day/date). JMP needs to fix this ... View more

Thanks Jim, this does the job. Great! Cheers, Kofi ... View more

Hi guys, thanks for reply. But the problem is not how to chose the column to create the overlay plot, but how to refer to the column to change the line colour etc in the graph. : how_do_I_refer_here_to_the_column_in_order_to_chang e (Connect Color( 20 ), Overlay Marker Color( 20 ),  Overlay Marker( 20 )), All the following option I've tried and they don't work: : name1 : (name1) : Column (name1) : (Column (name1)) : eval (name1) etc : Column (1)  or : (Column (1))   doesn't work either, by the way. Cheers, Kofi ... View more