topic Re: Shading a specific time (weekends) in graph builder in Discussions

Shading a specific time (weekends) in graph builder

H_1 — Thu, 25 Apr 2024 14:36:31 GMT

Hello, I am working on a graph looking at cyclical trends and was wondering, is there any way to apply shading to specific days/times in graph builder to draw attention to the specific ranges? I have attached an example image of what I'm trying to do below, where I added shading to the weekends in a photo editing platform.

Thank you!

Re: Shading a specific time (weekends) in graph builder

jthi — Fri, 26 Apr 2024 08:56:22 GMT

As you didn't provide data I will use jmp's steel shipments as example. Create new column which indicates weekends

You can then use this column as color in graph builder

You can then change the colors / transparency from legend settings

Also I'm fairly sure I have seen Scott Wise do something like this (https://community.jmp.com/t5/Scott-Wise-s-Blog/bg-p/swise-blog) but couldn't quickly find it.

Edit:

One thing to note about my solution is that it isn't really adding "shading". It will recolor your bars and sometimes that might not be what you want. For shading type of tasks the other options here are better

Re: Shading a specific time (weekends) in graph builder

H_1 — Thu, 25 Apr 2024 15:00:12 GMT

Fantastic, thank you for the prompt reply and instruction!

Re: Shading a specific time (weekends) in graph builder

Mark_Bailey — Thu, 25 Apr 2024 17:21:27 GMT

You can add Reference Lines to the time axis that span a range of values. See the example below and the axis dialog box.

Re: Shading a specific time (weekends) in graph builder

hogi — Thu, 25 Apr 2024 21:40:12 GMT

Reference lines are nice for 1-100 regions.

Beyond that, you could use Heatmap to get the weekends shaded fully automatically.

Nice tutorial by @John_Powell_JMP :

https://community.jmp.com/t5/Discussions/background-color-of-graph-builder/m-p/36095/highlight/true#M21243

dt = Open( "$SAMPLE_DATA/Airline Delays.jmp" );
New Column( "day",
	Format( "y/m/d", 12 ),
	Formula(
		Date DMY(
			:Day of Month,
			Match( :Month,"Jan", 1,"Feb", 2,"Mar", 3,"Apr", 4,"May", 5,	"Jun", 6,"Jul", 7,"Aug", 8,	"Sep", 9,"Oct", 10, "Nov", 11, "Dec", 12
			),
			1972
		) + In Hours( 12 )
	)
);
Graph Builder(
	Variables( X( :day ), Y( :Arrival Delay ), Color( :Day of Week ) ),
	Elements(
		Heatmap( X, Legend( 9 ) ),
		Points( X, Y, Color( 0 ), Legend( 7 ) )
	),
	SendToReport(
		Dispatch( {}, "400", ScaleBox,
			{Legend Model(
				9,
				Properties(
					0,
					{Fill Color( 16 ), Transparency( 0.2 )},
					Item ID( "Sun", 1 )
				),
				Properties( 1, {Transparency( 0 )}, Item ID( "Mon", 1 ) ),
				Properties( 2, {Transparency( 0 )}, Item ID( "Tue", 1 ) ),
				Properties( 3, {Transparency( 0 )}, Item ID( "Wed", 1 ) ),
				Properties( 4, {Transparency( 0 )}, Item ID( "Thur", 1 ) ),
				Properties( 5, {Transparency( 0 )}, Item ID( "Fri", 1 ) ),
				Properties( 6, {Transparency( 0 )}, Item ID( "Sat", 1 ) )
			)}
		)
	)
);

Re: Shading a specific time (weekends) in graph builder

hogi — Sat, 27 Apr 2024 11:57:10 GMT

The auto-adjustment of the tick spacing in GraphBuilder reduces the usefulness of the Heatmap approach - once you adjusted the tick spacing, don't dare to zoom in or out:

(view in My Videos)

So, for Jmp <=18 it's better to use @Mark_Bailey's approach - even for N>100 : ):)

Concerning a future version of Jmp - there is already a wish to fix the issue: