topic Re: how to analyse automaticly？ in Discussions

how to analyse automaticly？

TONYMA — Sun, 04 Jun 2017 15:16:14 GMT

dear all： i have to monito abnomal ratio every day， but now everyday i open the JMP and then put excel data in JMP to analyse， that is trouble。 if i open jmp and then analyse automaticly how i write JSL to realize？

Re: how to analyse automaticly？

txnelson — Sun, 04 Jun 2017 15:41:39 GMT

I apologize for possibly being too terse, but the small amount of details you provided only permits a very limited response

Names Default To Here( 1 );
// Open the excel file
dt = Open( "KY.xlsx" );

// Analyze the data

Could you please provide what you are doing to analyze the data? Or are you expecting the JMP Community to help you with what the data analysis should be?

Re: how to analyse automaticly？

TONYMA — Wed, 07 Jun 2017 13:42:49 GMT

thanks your answer，i want to anaysis like Append file，i want data analysis is should be if point over 0.3%，which over 0.3% point is changed to red colour 。

Re: how to analyse automaticly？

txnelson — Wed, 07 Jun 2017 15:40:04 GMT

If you remove your Graph Builder code, and add this code into your script, you will get your colors.

dt=current data table();
dt<<new column("Colors", ordinal,formula(If(:crack<=.003,1,2)));

dt << Graph Builder(
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Variables( X( :Month ), Y( :Crack ), Color( :Colors ) ),
	Elements( Points( X, Y, Legend( 3 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Crack",
			ScaleBox,
			{Min( 0.001 ), Add Ref Line( 0.003, "Dashed", "Dark Red", "", 1 )}
		)
	)
);