cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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
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.

Recommended Articles