BookmarkSubscribeSubscribe to RSS Feed
TONYMA

Community Trekker

Joined:

Feb 14, 2017

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
txnelson

Super User

Joined:

Jun 22, 2012

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

Community Trekker

Joined:

Feb 14, 2017

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

Joined:

Jun 22, 2012

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