Subscribe Bookmark RSS Feed

Scorecard with Static Data

jb

Community Trekker

Joined:

Sep 23, 2015

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

Joined:

Jun 23, 2011

Solution

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));
2 REPLIES
ian_jmp

Staff

Joined:

Jun 23, 2011

Solution

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

Community Trekker

Joined:

Sep 23, 2015

Thank you for the suggested approach and sample script.