Demonstrating Pareto's Law with JMP graph

[#1]

Hi everyone,

I will like to create a graph to show that 80% of the revenue comes from the top 20% of the customers in a store. My current data columns are:

1. CustomerID (around 4000+ data points)

2. Revenue

Would there be a way to build this graph in JMP? I've tried the Pareto Plot but have not been too successful.

Thank you! Cheers.

[#2]

Hi,

Would this kind of graph help?

Example data table attached.

Regards,

Phil

[#3]

Thank you Phil!

Yes it helps greatly. I was wondering if you could share how you did the ordering, as well as how you obtained the cumulative sales line? In addition, would it be possible for the cumulative sales to be in % instead?

I opened the Graph Builder script and could only see this:

[#4]

I am not sure why you graph looks so different when you run the Graph Builder script. I think it is partly due to preferences that you have set. But it should show the same cumulative sales curve.

Sales and Cumulative Sales plot.mp4

Video Player is loading.

Play Video

Play

Mute

Current Time 0:00

/

Duration 0:00

Loaded: 0%

0:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -0:00

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

There are a few clicks involved so I thought it would be best to record a short video demo.

Some key points to achieve the graph:

1. We order the Company axis by Sales by dragging Sales to the drop zone above centre of the x-axis.
2. We select order descending after right-click on the x-axis labels
3. We add Sales on the y-axis then we add it again (drop in the zone to the centre-right of the y-axis)
4. We right-click on the y-axis labels to move one of the instances of the Sales variable to the right
5. We change the statistic of the right y-axis to Cumulative Sum
6. We right-click on the white space in the plot to change between bar and point plots for the variables

Are you able to recreate the graph now?

Cheers,

Phil