cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Graph Builder: Option to hide categories with no data

What inspired this wish list request? 

We have the same issue/need as described in this User Community question: Solved: Graph Builder: hide X categories with no data - JMP User Community. Here it is solved by scripting, but I would be much better and more flexible to have an interactive solution.

The Graph Builder always shows all categories on the x-axis, and sometimes that is fine, but in other situations it is not. I know there is no data, e.g. this particular measurement wasn't done for all batches. So I don't want to see the batches that have no measurement on the x-axis. This can be solved by adding a Where to the Graph Builder script, but not everybody knows JSL. And if we also want to use a Column Switcher (like in the User Community question), it requires a lot of JSL. See Example1.jmp.

The default behavior of the Graph Builder is also a problem when using Page. E.g. we have measurements for a lot of batches from different factories. I use the measurement as Y, Batch as X and Factory as Page and make it a Bar plot. The x-axis shows all batches, which means that most of each plot is empty space, while I would like it to only show the batches where there is data, i.e. the batches for that particular Factory. See Example2.jmp. I currently solve this by changing the Page to By, but then we loose a lot of nice properties that come with the Page setup.

 

What is the improvement you would like to see? 

A setting (the current can be default) like "Ignore/Skip x-axis values/categories with no data" that can be selected interactively in the graph builder. It could be under the Bar element settings if it doesn't apply/make sense for other graph elements.

 

Why is this idea important? 

To avoid graphs with a lot of empty space which makes it impossible to see the trends we are actually looking for. To avoid having to do workarounds.

 

3 Comments
SarahGilyard
Staff
Status changed to: Acknowledged

Thank you MTOF for posting this suggestion. Not sure if this is helpful to you, but this type of graph below is possible in graph builder.  I will pass along this suggestion for inclusion in the wishlist prioritization survey. 

SarahGilyard_0-1728571064187.png

 

hogi
Level XIII

hi @MTOF , it's often the combination of values on the x axis and  X group or Page 
please have a look at :folded_hands: X group: restrict the values on the axis to the respective group . It collected Kudos since 2 years and has the status "Investigating".
Any additional Kudo will increase the chance that the issue gets fixed in JMP19 ...


We just had a survey in our company : which limitation of JMP hurts the most
and :folded_hands: X group: restrict the values on the axis to the respective group was the clear "winner".
As I mentioned in Wish list - new Label: user experience , many cool new features can now be easily implemented in JMP - by a detour through Python or R.
But when a function is missing in GraphBuilder, it hurts.

hogi
Level XIII

For Page, JMP support suggests this workaouround:

the column which is used for page - use it in addition on the X AXIS - as an additional level (like in @SarahGilyard 's example).
With page, the user can specify the range for each subplot - to show just the non-blank regions.

... it takes a while - and it's dangerous if additional categories are added. But it works.
For X Group, there is no workaround.