344667_en-US

liliconcom

Summarize function Date

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

Data TableScriptingRe: Summarize function Date

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"));

 

Re: Summarize function Date

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

Re: Summarize function Datewhat 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.Re: Summarize function Date

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.

 

Re: Summarize function Date

place a Num() function around the minT and see what happens. I agree, minT should be numeric

When you move your cursor over  minT what value is displayed?