how to analyse automaticly？

[#1]

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？

[#2]

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?

[#3]

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 。

[#4]

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