cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-803138%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EGraph%20Builder%3A%20Option%20to%20hide%20categories%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803138%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CSTRONG%3EWhat%20inspired%20this%20wish%20list%20request%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EWe%20have%20the%20same%20issue%2Fneed%20as%20described%20in%20this%20User%20Community%20question%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FGraph-Builder-hide-X-categories-with-no-data%2Fm-p%2F209809%22%20target%3D%22_blank%22%3ESolved%3A%20Graph%20Builder%3A%20hide%20X%20categories%20with%20no%20data%20-%20JMP%20User%20Community%3C%2FA%3E.%20Here%20it%20is%20solved%20by%20scripting%2C%20but%20I%20would%20be%20much%20better%20and%20more%20flexible%20to%20have%20an%20interactive%20solution.%3C%2FP%3E%3CP%3EThe%20Graph%20Builder%20always%20shows%20all%20categories%20on%20the%20x-axis%2C%20and%20sometimes%20that%20is%20fine%2C%20but%20in%20other%20situations%20it%20is%20not.%20I%20know%20there%20is%20no%20data%2C%20e.g.%20this%20particular%20measurement%20wasn't%20done%20for%20all%20batches.%20So%20I%20don't%20want%20to%20see%20the%20batches%20that%20have%20no%20measurement%20on%20the%20x-axis.%20This%20can%20be%20solved%20by%20adding%20a%20Where%20to%20the%20Graph%20Builder%20script%2C%20but%20not%20everybody%20knows%20JSL.%20And%20if%20we%20also%20want%20to%20use%20a%20Column%20Switcher%20(like%20in%20the%20User%20Community%20question)%2C%20it%20requires%20a%20lot%20of%20JSL.%20See%20Example1.jmp.%3C%2FP%3E%3CP%3EThe%20default%20behavior%20of%20the%20Graph%20Builder%20is%20also%20a%20problem%20when%20using%20Page.%20E.g.%20we%20have%20measurements%20for%20a%20lot%20of%20batches%20from%20different%20factories.%20I%20use%20the%20measurement%20as%20Y%2C%20Batch%20as%20X%20and%20Factory%20as%20Page%20and%20make%20it%20a%20Bar%20plot.%20The%20x-axis%20shows%20all%20batches%2C%20which%20means%20that%20most%20of%20each%20plot%20is%20empty%20space%2C%20while%20I%20would%20like%20it%20to%20only%20show%20the%20batches%20where%20there%20is%20data%2C%20i.e.%20the%20batches%20for%20that%20particular%20Factory.%20See%20Example2.jmp.%20I%20currently%20solve%20this%20by%20changing%20the%20Page%20to%20By%2C%20but%20then%20we%20loose%20a%20lot%20of%20nice%20properties%20that%20come%20with%20the%20Page%20setup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20is%20the%20improvement%20you%20would%20like%20to%20see%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EA%20setting%20(the%20current%20can%20be%20default)%20like%20%22Ignore%2FSkip%20x-axis%20values%2Fcategories%20with%20no%20data%22%20that%20can%20be%20selected%20interactively%20in%20the%20graph%20builder.%20It%20could%20be%20under%20the%20Bar%20element%20settings%20if%20it%20doesn't%20apply%2Fmake%20sense%20for%20other%20graph%20elements.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhy%20is%20this%20idea%20important%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ETo%20avoid%20graphs%20with%20a%20lot%20of%20empty%20space%20which%20makes%20it%20impossible%20to%20see%20the%20trends%20we%20are%20actually%20looking%20for.%20To%20avoid%20having%20to%20do%20workarounds.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-803138%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EData%20Exploration%20and%20Visualization%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804766%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20Builder%3A%20Option%20to%20hide%20categories%20with%20no%20data%20-%20Status%20changed%20to%3A%20Acknowledged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804766%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EThank%20you%20MTOF%20for%20posting%20this%20suggestion.%20Not%20sure%20if%20this%20is%20helpful%20to%20you%2C%20but%20this%20type%20of%20graph%20below%20is%20possible%20in%20graph%20builder.%26nbsp%3B%20I%20will%20pass%20along%20this%20suggestion%20for%20inclusion%20in%20the%20wishlist%20prioritization%20survey.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SarahGilyard_0-1728571064187.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22SarahGilyard_0-1728571064187.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22SarahGilyard_0-1728571064187.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22SarahGilyard_0-1728571064187.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22SarahGilyard_0-1728571064187.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F69001iF102203F03721239%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SarahGilyard_0-1728571064187.png%22%20alt%3D%22SarahGilyard_0-1728571064187.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804778%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%3A%20Graph%20Builder%3A%20Option%20to%20hide%20categories%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804778%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3Ehi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2319%22%20target%3D%22_blank%22%3E%40MTOF%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3Bit's%20often%20the%20combination%20of%20values%20on%20the%20x%20axis%20and%26nbsp%3B%26nbsp%3B%3CSTRONG%3EX%20group%3C%2FSTRONG%3E%26nbsp%3Bor%20%3CSTRONG%3EPage%26nbsp%3B%3C%2FSTRONG%3E%3CBR%20%2F%3Eplease%20have%20a%20look%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FX-group-restrict-the-values-on-the-axis-to-the-respective-group%2Fm-p%2F542325%23U542325%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%3CLI-EMOJI%20id%3D%22lia_folded-hands%22%20title%3D%22%3Amanos_unidas_para_la_oraci%C3%B3n%3A%22%3E%3C%2FLI-EMOJI%3E%20X%20group%3A%20restrict%20the%20values%20on%20the%20axis%20to%20the%20respective%20group%3C%2FA%3E%26nbsp%3B.%20It%20collected%20Kudos%20since%202%20years%20and%20has%20the%20status%20%22Investigating%22.%3CBR%20%2F%3EAny%20additional%20Kudo%20will%20increase%20the%20chance%20that%20the%20issue%20gets%20fixed%20in%20JMP19%20...%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20just%20had%20a%20survey%20in%20our%20company%20%3A%20which%20limitation%20of%20JMP%20hurts%20the%20most%3CBR%20%2F%3Eand%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FX-group-restrict-the-values-on-the-axis-to-the-respective-group%2Fm-p%2F542325%23U542325%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%3CLI-EMOJI%20id%3D%22lia_folded-hands%22%20title%3D%22%3Amanos_unidas_para_la_oraci%C3%B3n%3A%22%3E%3C%2FLI-EMOJI%3E%20X%20group%3A%20restrict%20the%20values%20on%20the%20axis%20to%20the%20respective%20group%3C%2FA%3E%26nbsp%3Bwas%20the%20clear%20%22winner%22.%3CBR%20%2F%3EAs%20I%20mentioned%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FCommunity-Wish-List%2FWish-list-new-Label-user-experience%2Fm-p%2F709540%23U709540%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EWish%20list%20-%20new%20Label%3A%20user%20experience%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%2C%20many%20cool%20new%20features%20can%20now%20be%20easily%20implemented%20in%20JMP%20-%20by%20a%20detour%20through%20Python%20or%20R.%3CBR%20%2F%3EBut%20when%20a%20function%20is%20missing%20in%20GraphBuilder%2C%20it%20hurts.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804781%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20Builder%3A%20Option%20to%20hide%20categories%20with%20no%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804781%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EFor%20Page%2C%20JMP%20support%20suggests%20this%20workaouround%3A%3C%2FP%3E%3CP%3Ethe%20column%20which%20is%20used%20for%20page%20-%20use%20it%20in%20addition%20on%20the%20X%20AXIS%20-%20as%20an%20additional%20level%20(like%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F54402%22%20target%3D%22_blank%22%3E%40SarahGilyard%3C%2FA%3E%26nbsp%3B's%20example).%3CBR%20%2F%3EWith%20page%2C%20the%20user%20can%20specify%20the%20range%20for%20each%20subplot%20-%20to%20show%20just%20the%20non-blank%20regions.%3CBR%20%2F%3E%3CBR%20%2F%3E...%20it%20takes%20a%20while%20-%20and%20it's%20dangerous%20if%20additional%20categories%20are%20added.%20But%20it%20works.%3CBR%20%2F%3EFor%20%3CSTRONG%3EX%20Group%3C%2FSTRONG%3E%2C%20there%20is%20no%20workaround.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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 XII

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
Level XII

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.