Best Visual?

Question

All,

I am looking to see how you all might use JMP ro visualise the data below.

Each year shows the rolling total required.

For example, Role A adds 2 head in 2018, then 2 more (4 total) in 2019, then 4 more (8 total) in 2020 etc.

Role/Year

2017

2018

2019

2020

2021

Role A

0

2

4

8

16

Role B

2

4

6

9

12

Role C

1

4

6

8

10

Role D

0

2

6

Role E

0

2

3

4

5

Role F

0

1

2

4

5

Role G

0

2

4

I can make really basic visuals in ppt (see pic attached), but am looking for more snap.

Should I consider transposing data? Would it work well as a tree map...?

I am completly open to suggestions...

MikeD_Anderson · Accepted Answer

A couple of ideas  - run the scripts in the attached data tables.

M

pmroz · Accepted Answer

How about a stacked bargraph?

Here's the JSL code:

Graph Builder(
	Size( 533, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :Year ), Y( :Count ), Overlay( :Role ) ),
	Elements( Bar( X, Y, Legend( 11 ), Bar Style( "Stacked" ) ) ),
	SendToReport(
		Dispatch( {}, "Count", ScaleBox, {Label Row( Show Major Grid( 1 ) )} )
	)
);

Peter_Bartell · Accepted Answer

I agree 1000% with my colleague @MikeD_Anderson and JMP User and friend @pmroz. Think about your message first...get cute later. If your message is one of rate of change across roles over time, then perhaps the attached overlay plot or some variation within Graph Builder might be effective? Perhaps laying on a local data filter once the graph is created as well?

dale_lehman · Accepted Answer

I'm agreeing with others here - snap is out, understanding is in.  I've used M_Anderson's file and added four more scripts.  One (the treemap) shows how the overall size and roles shift over time.  The second is the cleanest display of the data - but a but too busy given the relatively large number of roles displayed on one graph (you could always put the roles into wrap, as the next script shows).  While it clearly shows the data without need for much effort, it is probably the furthest away from "snap" you can get.  The fourth is the stacked bar chart already shown - it is an efficient display, but I'm not too fond of stacked bar charts as only a few major features are readily interpreted by your eyes - much of the detail is simply not comprehensible given the varying sizes of the bars.  If you wanted to emphasize the makeup by roles, you could always standardize the totals and show the percent in each role.  In that sense, I think the treemap may be best here since it shows both the makeup and the overall size.

To get better displays, I think you need to spend the effort on thinking about the question you want the graph(s) to answer.  You may also be able to combine the roles into a smaller number since some of the role staffing seem to behave similarly and some seem less important than others.