nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Simple line plots

BHarris

This seems like it should be pretty easy, but it's not, and it's something I often run into and wonder if there's an easier way.

Here's an example dataset from https://blog.scoutingmagazine.org/2019/02/11/2018-merit-badge-rankings-a-deep-dive-into-the-official-numbers-from-1-to-137

I would like to build a single plot with a line for each merit badge. There will be a bunch on top of each other, but suppose I'm interested in the standouts, the lines at the top and bottom.

I went through the hassle of making it in Excel to show what I'm trying to do:

Is there a good way to do this with JMP?

Accepted answers

wjlevin

I've managed to make this happen.

First, I simply copied and pasted the table from the article into a JMP table using Edit > Paste with Column Names.

Second, I had to change a couple of columns to be Numeric, Continuous because they had some character data within it.

I then stacked the data table and used Graphbuilder to create the graph.

I put it all in a script (except the changing the column attributes - though I could have scripted that too). See attached.

Merit.jmp

All comments

wjlevin

I've managed to make this happen.

First, I simply copied and pasted the table from the article into a JMP table using Edit > Paste with Column Names.

Second, I had to change a couple of columns to be Numeric, Continuous because they had some character data within it.

I then stacked the data table and used Graphbuilder to create the graph.

I put it all in a script (except the changing the column attributes - though I could have scripted that too). See attached.

Merit.jmp

BHarris

Wow, okay -- that's fantastic!

The key was making the badges an overlay, which never entered my mind. I thought I'd have to put intermediate lines between the sections with "." in all the columns to make the lines break. What is overlay supposed to be anyway? (I'll just read the manual, but it's never made a lot of sense to me.)

The stacking was also important. Fundamentally it seems there are two ways of storing data in a table: (1) column and row headers are inputs, and cells are outputs (which is the data we started with here), and (2) inputs are in some columns and outputs are in other columns (which is what we ended up with here). JMP seems to naturally work with data like #2, and you can convert #1 into #2 using "stack". But #2 seems to be far less efficient in terms of RAM usage. Am I thinking about that right? Is that something I should be concerned with?

Thank you!!

Mark_Bailey

I'm glad that Wayne's solution worked for you. Graph Builder is very powerful, but it takes some study to master it. This time is well worth it.

See Help > Books > Essential Graphing. There a general principals and specific examples to guide you next time.

BHarris

I've been through it, but some parts of it aren't terribly clear -- for example, "Overlay" says that it "subgroups and colors", but "Color" seems to do the same thing (except for subgrouping??). Even after reading that section I would not have known to do what Wayne did, but thanks to him I understand it better.