cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-280285%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%E4%B8%BA%E5%88%97%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E8%A1%8C%E7%94%9F%E6%88%90%E8%BF%B7%E4%BD%A0%E5%9B%BE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-280285%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%E6%88%91%E6%83%B3%E8%A6%81%E5%81%9A%E7%9A%84%E6%98%AF%E6%88%91%E5%9C%A8%E5%85%B6%E4%B8%AD%E4%B8%80%E4%B8%AA%20FDE%20%E6%95%99%E7%A8%8B%3CA%20title%3D%22%E4%BD%BF%E7%94%A8%20JMP%C2%AE%20Pro%20%E9%A2%84%E5%A4%84%E7%90%86%E5%87%BD%E6%95%B0%E6%95%B0%E6%8D%AE%E5%B9%B6%E5%88%9B%E5%BB%BA%E6%9B%BF%E4%BB%A3%E6%A8%A1%E5%9E%8B%22%20href%3D%22http%3A%2F%2Fwww.jmp.com%2Fen_us%2Fevents%2Fondemand%2Fmastering-jmp%2Ffunctional-data-explorer-part-1.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%E3%80%8A%E4%BD%BF%E7%94%A8%20JMP%C2%AE%20Pro%20%E9%A2%84%E5%A4%84%E7%90%86%E5%8A%9F%E8%83%BD%E6%95%B0%E6%8D%AE%E5%B9%B6%E5%88%9B%E5%BB%BA%E4%BB%A3%E7%90%86%E6%A8%A1%E5%9E%8B%E3%80%8B%3C%2FA%3E%E4%B8%AD%E7%9C%8B%E5%88%B0%E8%BF%87%E7%9A%84%E6%93%8D%E4%BD%9C%EF%BC%8C%E4%BD%86%E6%88%91%E6%89%BE%E4%B8%8D%E5%88%B0%E6%8F%8F%E8%BF%B0%E5%A6%82%E4%BD%95%E5%88%9B%E5%BB%BA%E6%89%80%E6%98%BE%E7%A4%BA%E6%95%B0%E6%8D%AE%E7%9A%84%E4%BB%A3%E7%A0%81%EF%BC%9A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%20%3C%2FDIV%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E6%88%91%E5%A6%82%E4%BD%95%E4%BD%BF%E7%94%A8%E6%88%91%E8%87%AA%E5%B7%B1%E7%9A%84%E6%95%B0%E6%8D%AE%E5%88%9B%E5%BB%BA%E5%83%8F%20X3%20%E8%BF%99%E6%A0%B7%E7%9A%84%E5%88%97%EF%BC%9F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EX3%20%E6%98%AF%E4%B8%80%E4%B8%AA%E4%BA%A4%E4%BA%92%E5%BC%8F%E5%88%97%EF%BC%88%E4%BE%8B%E5%A6%82%EF%BC%8C%E5%8F%AF%E4%BB%A5%E4%BF%AE%E6%94%B9%E6%88%96%E6%9B%B4%E6%96%B0%EF%BC%89%E8%BF%98%E6%98%AF%E5%8F%AA%E6%98%AF%E4%B8%80%E4%B8%AA%E5%9B%BE%E7%89%87%E5%88%97%EF%BC%8C%E5%B0%B1%E5%83%8F%E6%88%91%E5%9C%A8%E5%85%B6%E4%BB%96%E7%A4%BA%E4%BE%8B%EF%BC%88%E4%BE%8B%E5%A6%82%E5%A4%A7%E7%B1%BB%E5%AE%B6%E5%BA%AD%E6%A0%B7%E6%9C%AC%E6%95%B0%E6%8D%AE%EF%BC%89%E4%B8%AD%E7%9C%8B%E5%88%B0%E7%9A%84%E9%82%A3%E6%A0%B7%EF%BC%9F%3C%2FP%3E%3CP%3E%E5%89%8D%E8%80%85%E4%BC%9A%E6%9B%B4%E6%9C%89%E8%B6%A3%EF%BC%8C%E4%BD%86%E5%A6%82%E6%9E%9C%E6%9C%89%E5%BF%85%E8%A6%81%E7%9A%84%E8%AF%9D%E6%88%91%E5%8F%AF%E4%BB%A5%E6%8E%A5%E5%8F%97%E5%90%8E%E8%80%85%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E9%9D%9E%E5%B8%B8%E6%84%9F%E8%B0%A2%E6%82%A8%E7%9A%84%E5%B8%AE%E5%8A%A9%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-280285%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3E%E6%95%B0%E6%8D%AE%E6%B7%B7%E5%90%88%E5%92%8C%E6%B8%85%E7%90%86%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-380796%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E4%B8%BA%E5%88%97%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E8%A1%8C%E7%94%9F%E6%88%90%E8%BF%B7%E4%BD%A0%E5%9B%BE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-380796%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E8%B0%A2%E8%B0%A2%E4%BD%A0%E5%88%86%E4%BA%AB%E8%BF%99%E4%B8%AA%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20%E5%92%8C%20Gsheets%20%E5%8F%AF%E4%BB%A5%E9%80%9A%E8%BF%87%E7%AE%80%E5%8D%95%E7%9A%84%E5%85%AC%E5%BC%8F%E7%9B%B4%E6%8E%A5%E5%88%9B%E5%BB%BA%E8%BF%B7%E4%BD%A0%E5%9B%BE%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E6%83%B3%E7%9F%A5%E9%81%93%20JMP%20%E4%BD%95%E6%97%B6%E4%BC%9A%E5%B0%86%E5%85%B6%E5%8C%85%E5%90%AB%E5%9C%A8%E5%85%B6%E6%A0%87%E9%A2%98%E4%B8%AD%EF%BC%88%E5%88%B0%E7%9B%AE%E5%89%8D%E4%B8%BA%E6%AD%A2%E4%BB%85%E6%98%BE%E7%A4%BA%E5%88%86%E5%B8%83%EF%BC%89%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FColumn-headers-with-sparklines%2Fidi-p%2F279970%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FColumn-headers-with-sparklines%2Fidi-p%2F279970%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-280472%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E4%B8%BA%E5%88%97%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E8%A1%8C%E7%94%9F%E6%88%90%E8%BF%B7%E4%BD%A0%E5%9B%BE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-280472%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15287%22%20target%3D%22_blank%22%3E%40Feli%3C%2FA%3E%20%2C%3C%2FP%3E%0A%3CP%3E%E4%BD%BF%E7%94%A8%E5%9B%BE%E5%BD%A2%E7%94%9F%E6%88%90%E5%99%A8%E5%88%9B%E5%BB%BA%E5%9B%BE%E5%BD%A2%E3%80%82%3C%2FP%3E%0A%3CP%3E%E5%8D%95%E5%87%BB%E7%BA%A2%E8%89%B2%E4%B8%89%E8%A7%92%E5%BD%A2%E4%B8%AD%E7%9A%84%20Make%20Into%20Data%20Table%20%E9%80%89%E9%A1%B9%E4%BB%A5%E5%88%9B%E5%BB%BA%E5%9B%BE%E8%A1%A8%E8%A1%A8%E3%80%82%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F25564iC0AD0E775D62601F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Make%20into%20data%20table%20graphbuilder%20graphs.png%22%20alt%3D%22Sparklines%20using%20JMP%20GraphBuilder%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESparklines%20using%20JMP%20GraphBuilder%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESparklines%20using%20JMP%20GraphBuilder%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESparklines%20using%20JMP%20GraphBuilder%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3ESparklines%20using%20JMP%20GraphBuilder%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E%E4%BD%BF%E7%94%A8%20JMP%20GraphBuilder%20%E7%9A%84%E8%BF%B7%E4%BD%A0%E5%9B%BE%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E4%BD%BF%E7%94%A8%20Raleigh%20Temps%20%E7%A4%BA%E4%BE%8B%E6%95%B0%E6%8D%AE%E8%A1%A8%EF%BC%8C%E6%88%91%E4%BD%BF%E7%94%A8%20Graph%20Builder%20%E5%88%9B%E5%BB%BA%E4%BA%86%E4%B8%80%E4%B8%AA%E6%8A%98%E7%BA%BF%E5%9B%BE%EF%BC%8C%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%20-%3C%2FP%3E%0A%3CP%3E%E6%88%91%E5%B0%86%E5%B9%B4%E4%BB%BD%E4%BB%8E%E8%BF%9E%E7%BB%AD%E6%9B%B4%E6%94%B9%E4%B8%BA%E5%BA%8F%E6%95%B0%EF%BC%8C%E5%9B%A0%E6%AD%A4%E6%88%91%E5%8F%AF%E4%BB%A5%E4%B8%BA%E6%AF%8F%E4%B8%AA%E5%9B%BE%E8%A1%A8%E8%AE%BE%E7%BD%AE%E4%B8%80%E5%B9%B4%E3%80%82%3C%2FP%3E%0A%3CP%3EY%EF%BC%9A%E6%B8%A9%E5%BA%A6%3C%2FP%3E%0A%3CP%3EX%EF%BC%9A%E6%9C%88%3C%2FP%3E%0A%3CP%3E%E5%88%86%E9%A1%B5%EF%BC%9A%E5%B9%B4%E4%BB%BD%3C%2FP%3E%0A%3CP%3E%E7%94%A8%E4%BA%8E%E5%88%9B%E5%BB%BA%E5%9B%BE%E5%BD%A2%E7%9A%84%20JSL%20%E8%84%9A%E6%9C%AC%E2%80%94%E2%80%94%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EGraph%20Builder(%0A%20Variables(%20X(%20%3AMonth%20)%2C%20Y(%20%3ATemperature%20)%2C%20Page(%20%3AYear%20)%20)%2C%0A%20Elements(%20Line(%20X%2C%20Y%2C%20Legend(%204%20)%20)%20)%2C%0A%20SendToReport(%0A%20%20Dispatch(%0A%20%20%20%7B%7D%2C%0A%20%20%20%22400%22%2C%0A%20%20%20ScaleBox%2C%0A%20%20%20%7BLegend%20Model(%0A%20%20%20%204%2C%0A%20%20%20%20Properties(%20-1%2C%20%7BLine%20Width(%204%20)%7D%2C%20Item%20ID(%20%22Mean%22%2C%201%20)%20)%0A%20%20%20)%7D%0A%20%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

Recommended Articles