Re: Traffic Lights and Gauges in Jmp Dashboards?

hogi · Jul 16, 2023 1:40 AM

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" );
			)}
		)
	)
)