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; } } }

Summarize function Date

dhurw

I pretty new to jmp and have been trying to gain as much knowledge as possible on the the scripting language. I have been referencing both the scripting guide and the index if I run into any issues. As far as the Summarize function is concerned, is there somethin I am missing.... I am attempting to pull the min and max date and I am getting a rather large numerical value.

As far as the formatting is concerned this is what I have..

Summarize(
	pNum = By( :Part Number ), 

	minL = Min( :Start Length ),
	maxL = Max( :Start Length ),
	massM = Mean( :Name( "Mass (g/m2)" ) ),
	sDevM = Std Dev( :Name( "Mass (g/m2)" ) ),
	minT = Min( :Time ) ,
	maxT = Max( :Time ) 
);

Accepted answers

txnelson

I should have realized this earlier. Because the Summarize() has a by group, the values of minT and maxT are matrices. If you change the Show() line to

Show( Format( minT[1], "m/d/y h:m:s" ), Format( maxT[1], "m/d/y h:m:s" ) );

you should see the min and max times for the first Part Number

All comments

txnelson

JMP DateTime variables are numeric values based upon the number of seconds since January 1, 1904. Therefore the actual numeric value is a very large number. To display the value as a time value, the easiest way, is to specify a format() function.

Summarize(
	pNum = By( :Part Number ), 

	minL = Min( :Start Length ),
	maxL = Max( :Start Length ),
	massM = Mean( :Name( "Mass (g/m2)" ) ),
	sDevM = Std Dev( :Name( "Mass (g/m2)" ) ),
	minT = Min( :Time ) ,
	maxT = Max( :Time ) 
);

show( format(minT, "m/d/y h:m:s"),format(maxT, "m/d/y h:m:s"));

dhurw

Unfortunately, that is not working for this script. The original script was not made by me, although I assume this is the culprit.

Column( SqlQry1, "DateTime" ) << data type( "Numeric" );
SqlQry1 << New Column( "Time", formula( Round( :DateTime, 0 ) ) );

Column( SqlQry1, "Time" ) << Format( "m/d/y h:m:s" ) << delete formula;
//Column( SqlQry1, "Time")  << Modeling Type( "Nominal");
SqlQry1 << delete column( "DateTime" );
dt0 = SqlQry1 << split( split by( :TagName ), Split( :vValue ), group( :Time ) );
Close( SqlQry1, no save );

txnelson

what do you mean when you say it isn't working? Without having an actual sample of your data table, I am not seeing anything of issue.

dhurw

I am getting this error...

Which to me doesn't make sense, in that the column was created utilizing the previous script as a numeric time column.

The data is being pulled from an SQL server.