cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
jb
jb
Level IV

Scorecard with Static Data

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
Staff

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
Staff

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.