topic Re: Scripting, specifically to automate graphing of data for the last 30 days in Discussions

Scripting, specifically to automate graphing of data for the last 30 days

VO — Fri, 09 Jun 2023 17:04:52 GMT

Novice on scripting, using JMP 16, looking for help to graph, the last 30 days of data - from today's date.

Currently using local data filter and selecting points, but there must be a better way to add this to the script, please advise.

Thanks!

Local Data Filter(
		Auto clear( 1 ),
		Add Filter(
			columns( :Recipe, :Date ),
			Where(
				:Date == {"220509", "220511", "220513", "220516", "220517", "220524",
				"220526", "220531", "220602", "220608", "220613", "220614", "220616",
				"220620", "220621", "220713", "220718", "220719"}
			),
			Display( :Recipe, N Items( 15 ) ),
			Display( :Date, N Items( 15 ), Find( Set Text( "" ) ) )
		)

Re: Scripting, specifically to automate graphing of data for the last 30 days

txnelson — Wed, 20 Jul 2022 22:07:41 GMT

To start, I suggest that you convert your Date column to a JMP Date/Time value. The current Date column is just a character column, which follows Alphanumeric rules, not Date/Time rules. Here is a simple script that will create a new column called JMPDate, whch will be transformed from your Date column

Names Default To Here( 1 );
dt = Current Data Table();

dt << New Column( "JMPDate",
	set each value(
		Date MDY(
			Num( Substr( :date, 3, 2 ) ),
			Num( Right( :date, 2 ) ), 
			Num( "20" || Left( :date, 2 ) )
		)
	),
	Format( "m/d/y" )
);

Once it is a JMP Date/Time column, you can do such things as

dt << select where(:JMPDate > 05/31/2022);

dt << select where(:JMPDate > Today() - inDays(180));

Re: Scripting, specifically to automate graphing of data for the last 30 days

VO — Tue, 26 Jul 2022 21:19:30 GMT

Thanks for the help "txnelson," but not an easy fix, since it appears that perhaps I worded the question wrong or incomplete.

The Date column is being created / sourced from the name column, which is the output file from the tool, that encompasses a description of several characteristics specific to the run, in this manner: "Date_tool Id_ recipe_ material_position_run#." That said, since the source of this original column is set to Character, the newly created "Date" column (done for ease of plotting) will not accept the change from Character to Date. Any idea why? Or better suggestion for the Date column formula?

Item( 1, :Source, "_" )

Re: Scripting, specifically to automate graphing of data for the last 30 days

txnelson — Wed, 27 Jul 2022 00:38:24 GMT

Has a Lock been placed on the Date column, or is the Date column being used to set values in other columns through formulas?

The new column, JMPDate should be being created correctly. You can use that column for the selection, etc.

Re: Scripting, specifically to automate graphing of data for the last 30 days

VO — Wed, 27 Jul 2022 15:23:13 GMT

I think that is the problem, the column is locked automatically, so it does not take the Date change. Also, no other columns are dependent on this Date column.

Attempted to recreate a new column, with the same Formula, and as soon as the formula is applied it locks that column as well.

Re: Scripting, specifically to automate graphing of data for the last 30 days

txnelson — Wed, 27 Jul 2022 17:34:23 GMT

Click on the red triangle in the Table Panel and unselect the Lock Table setting

Re: Scripting, specifically to automate graphing of data for the last 30 days

VO — Wed, 27 Jul 2022 17:40:47 GMT

The "Lock Data Table" was not selected. I tried unlocking the column with and without the selection, and neither worked.

Re: Scripting, specifically to automate graphing of data for the last 30 days

txnelson — Wed, 27 Jul 2022 17:43:35 GMT

How is the table created? The platform that is used to create the table, many times has an option to link/lock the new table. If so, change the linking in the table creation.

Re: Scripting, specifically to automate graphing of data for the last 30 days

Mark_Bailey — Wed, 27 Jul 2022 17:58:05 GMT

(Apologies to @txnelson because I left the discussion window open from earlier and did not see his reply.)

Let's start over. I would add a data column for the converted date value (numeric) and leave the original date value (character) as it is. So the data table now might look like this:

The New Date column is numeric values formatted as dates. See this dialog to understand the attributes of the new data column:

A simple formula deconstructs the original character string to build a proper JMP time value:

Now use New Date for your filter instead of Date. It doesn't matter about whether the column is locked.