Traffic Lights and Gauges in Jmp Dashboards?

hogi — Sun, 16 Jul 2023 08:40:50 GMT

In Jmp Dashboards, is there a function to add Traffic Lights and Gauge Views?

https://grafana.com/grafana/plugins/snuids-trafficlights-panel/

https://kerrykolosko.com/portfolio-category/svg-templates/

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

gb = Graph Builder(
	Size( 437, 413 ),
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :height ), Y( :weight ), Overlay( :sex ) ),
	Elements( Points( X, Y, Legend( 1 ) ), Line Of Fit( X, Y, Legend( 3 ) ) )
);

dt << New Column( "BMI",
	Formula(
		If(
			:weight > :"Upper Fit(weight)"n, 1,
			:weight < :"Lower Fit(weight)"n, -1,
			0
		)
	)
);

Report(gb)[GraphBuilderBox(1)] << updateElement(1, 1, 2, {Save Formula});
dt << Graph Builder(
	Size( 117, 262 ),
	Show Control Panel( 0 ),
	Show Legend( 0 ),
	Show Title( 0 ),
	Show Footer( 0 ),
	Show X Axis( 0 ),
	Show Y Axis( 0 ),
	Show X Axis Title( 0 ),
	Show Y Axis Title( 0 ),
	Lock Scales( 1 ),
	Fit to Window( "Off" ),
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :name ), Y( :BMI ), Color( :BMI ) ),
	Elements( Points( X, Y, Legend( 55 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :name ),
			Where( :name == "MICHAEL" ),
			Display( :name, N Items( 6 ), Find( Set Text( "" ) ) )
		)
	),
	SendToReport(
		Dispatch(
			{},
			"name",
			ScaleBox,
			{Format( "Best", 9 ), Min( -0.25 ), Max( 0.25 ), Inc( 1 ), Minor Ticks( 0 )}
		),
		Dispatch(
			{},
			"BMI",
			ScaleBox,
			{Format( "Best", 12 ), Min( -2 ), Max( 2 ), Inc( 0.2 ), Minor Ticks( 0 ),
			Label Row( {Show Major Grid( 0 ), Show Major Labels( 0 )} )}
		),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				55,
				Properties(
					0,
					{gradient(
						{Color Theme(
							{"Stoplight Bad to Good Copy", 4099, {"Red", "Yellow", {255, 255, 0}, "Green",
							Missing( {110, 110, 110} )}, {0.183431952662722, 0.340236686390533,
							0.529585798816568, 1}, 1, 1}
						), Scale Values( [-1 0 1] ), Reverse Gradient( 1 ), N Labels( 11 ),
						Label Format( "Fixed Dec", 12, 2 )}
					)},
					Item ID( "BMI", 1 )
				)
			)}
		),
		Dispatch(
			{},
			"Graph Builder",
			FrameBox,
			{Marker Size( 40 ), Marker Drawing Mode( "Outlined" ),
			Add Graphics Script(
				2,
				Description( "" ),
				Fill Color( gray );
				Rect( -0.18, 1.8, 0.18, -1.8, 1 );
				Fill Color( red );
				Transparency( 0.2 );
				Circle( {0, 1}, 0.4, "FILL" );
				Fill Color( yellow );
				Circle( {0, 0}, 0.4, "FILL" );
				Fill Color( green );
				Circle( {0, -1}, 0.4, "FILL" );
			)}
		)
	)
)

Re: Traffic Lights and Gauges in Jmp Dashboards?

David_Burnham — Mon, 17 Jul 2023 01:22:23 GMT

Not that I'm aware of. My approach is to use images:

Re: Traffic Lights and Gauges in Jmp Dashboards?

Florian_Vogt — Mon, 17 Jul 2023 07:23:22 GMT

Hi @hogi ,

have you tried using Mapshapes?

Here is an example and helpful addin:

https://community.jmp.com/t5/JMP-Add-Ins/Custom-Map-Creator/ta-p/21479

or more info in the help:

https://www.jmp.com/support/help/en/17.2/index.shtml#page/jmp/custom-map-files.shtml

Best

Florian

Re: Traffic Lights and Gauges in Jmp Dashboards?

hogi — Mon, 17 Jul 2023 22:21:40 GMT

nice trick :)
and the images are automatically updated when the user adjusts the Cp and Cpk sliders?

Re: Traffic Lights and Gauges in Jmp Dashboards?

David_Burnham — Wed, 19 Jul 2023 17:45:51 GMT

Yes. And if you click on it, it launches the full analysis.

topic Traffic Lights and Gauges in Jmp Dashboards? in Discussions

Traffic Lights and Gauges in Jmp Dashboards?

Re: Traffic Lights and Gauges in Jmp Dashboards?

Re: Traffic Lights and Gauges in Jmp Dashboards?

Re: Traffic Lights and Gauges in Jmp Dashboards?

Re: Traffic Lights and Gauges in Jmp Dashboards?