Graph Builder: Option to hide categories with no data

[MTOF]

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.

Example1.jmp

Example2.jmp

[SarahGilyard]

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. 

[hogi]

hi @MTOF , it's often the combination of values on the x axis and  X group or Page 
please have a look at 🙏 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 🙏 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]

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.