cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Scorecard with Static Data

jb
jb
Level IV

I am trying to create a static scorecard that looks something like this:

 

Scorecard.png

 

I looked at JMP Dashboard Builder, but it seems to be tailored to complex graphs with filtering, maps, and interactivity.  I just want something simple and static.

 

Elements I wish to include are:

  • Large-Font Numbers
  • Textual Footnotes to explain the numbers
  • Plain Excel-like Tables (NOT JMP Data Tables)
  • JMP Graphs

Goal is to save the scorecard as a PDF for distribution each month.  (Since 20+ managers need their own scorecard each month, I plan to script this once I have a layout.)

 

Any suggestions on designing the layout?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ian_jmp
Level X


Re: Scorecard with Static Data

If you do 'Help > Scripting Index' and learn about the 'display boxes' that are available and the messages that they understand, I imagine that you could build a reasonable facsimilie. Here's a start:

NamesDefaultToHere(1);
NewWindow("Customer Serice Scorecard",
	TextBox("Customer Serice Scorecard", <<setFontSize(48), <<fontColor("Blue"), <<setWrap(700)),
	LineUpBox(NCol(3),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		SpacerBox(Size(20, 20)),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			)
	)
);

dt = Open("$SAMPLE_DATA/Big Class.jmp", Invisible);
NewWindow("Not a JMP Table", <<onClose(Close(dt, NoSave)), DataTableBox(dt));

View solution in original post

2 REPLIES 2
ian_jmp
Level X


Re: Scorecard with Static Data

If you do 'Help > Scripting Index' and learn about the 'display boxes' that are available and the messages that they understand, I imagine that you could build a reasonable facsimilie. Here's a start:

NamesDefaultToHere(1);
NewWindow("Customer Serice Scorecard",
	TextBox("Customer Serice Scorecard", <<setFontSize(48), <<fontColor("Blue"), <<setWrap(700)),
	LineUpBox(NCol(3),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		SpacerBox(Size(20, 20)),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			),
		SpacerBox(Size(20, 20)),
		VListBox(
			TextBox("Customer Satisfaction", <<setFontSize(24), <<fontColor("Gray")),
			TextBox("97%", <<setFontSize(72)),
			TextBox("of customers are satisfied with the . . .", <<setFontSize(10))
			)
	)
);

dt = Open("$SAMPLE_DATA/Big Class.jmp", Invisible);
NewWindow("Not a JMP Table", <<onClose(Close(dt, NoSave)), DataTableBox(dt));
jb
jb
Level IV


Re: Scorecard with Static Data

Thank you for the suggested approach and sample script.