Subscribe Bookmark RSS Feed

how to analyse automaticly?

TONYMA

Occasional Contributor

Joined:

Feb 14, 2017

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?
i am god of yours
3 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Occasional Contributor

Joined:

Feb 14, 2017

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 。
i am god of yours
txnelson

Super User

Joined:

Jun 22, 2012

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