cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
TONYMA
Level III

how to analyse automaticly?

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?
you are your god.
3 REPLIES 3
txnelson
Super User

Re: how to analyse automaticly?

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?

Jim
TONYMA
Level III

Re: how to analyse automaticly?

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 。
you are your god.
txnelson
Super User

Re: how to analyse automaticly?

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