cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Feli
Level IV

Generating sparklines for each row in a column

What I want to do is something I have seen in one of the FDE tutorials Using JMP® Pro to Pre-Process Functional Data and Create Surrogate Models, but I can't find the code that describes how the shown data was created:

 

 

How would I create a column like X3 with my own data?

 

Is X3 an interactive column (e.g., can be modified or updated) or just a picture column like I have seen in other examples like the Big class families sample data?

The former would be more interesting, but I could live with the latter if necessary.

 

Many thanks for your help

1 ACCEPTED SOLUTION

Accepted Solutions
stan_koprowski
Community Manager Community Manager

Re: Generating sparklines for each row in a column

Hi @Feli,

Create a graph using graph builder.

Click the Make Into Data Table option from the red triangle to create a table of graphs.

Sparklines using JMP GraphBuilderSparklines using JMP GraphBuilder

 

Using the Raleigh Temps sample data table I created a line graph using Graph Builder as follows--

I changed year to ordinal from continuous so I can have a single year for each graph.

Y: Temperature

X: Month

Page By: Year

JSL Script for creating the graph--

Graph Builder(
	Variables( X( :Month ), Y( :Temperature ), Page( :Year ) ),
	Elements( Line( X, Y, Legend( 4 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				4,
				Properties( -1, {Line Width( 4 )}, Item ID( "Mean", 1 ) )
			)}
		)
	)
);

 

 

 

View solution in original post

2 REPLIES 2
stan_koprowski
Community Manager Community Manager

Re: Generating sparklines for each row in a column

Hi @Feli,

Create a graph using graph builder.

Click the Make Into Data Table option from the red triangle to create a table of graphs.

Sparklines using JMP GraphBuilderSparklines using JMP GraphBuilder

 

Using the Raleigh Temps sample data table I created a line graph using Graph Builder as follows--

I changed year to ordinal from continuous so I can have a single year for each graph.

Y: Temperature

X: Month

Page By: Year

JSL Script for creating the graph--

Graph Builder(
	Variables( X( :Month ), Y( :Temperature ), Page( :Year ) ),
	Elements( Line( X, Y, Legend( 4 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				4,
				Properties( -1, {Line Width( 4 )}, Item ID( "Mean", 1 ) )
			)}
		)
	)
);

 

 

 

FN
FN
Level VI

Re: Generating sparklines for each row in a column

Thanks for sharing this.

 

Excel and Gsheets have a direct way to create sparklines with a simple formula.

 

I wonder when JMP will include that on their headers (so far only showing distributions).

 

https://community.jmp.com/t5/JMP-Wish-List/Column-headers-with-sparklines/idi-p/279970