cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-775809%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EGraph%20Builder-Hide%20Categorical%20Nominal%20Levels%20on%20Y-axis%20not%20used%20in%20specific%20Pages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775809%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EI%20have%20a%20data%20table%20that%20has%20a%20datetime%20column%20modelled%20as%20numeric-continuous.%26nbsp%3B%20I%20have%20various%20Serial%20Numbers%20(%22SN%22%2C%20Categorical-Nominal)%20in%20another%20column%2C%20along%20with%20another%20Categorical-Nominal%20column%2C%20we%20can%20call%20%22Y%22.%26nbsp%3B%20I%20want%20to%20see%20when%20certain%20%22Y%22%20events%20occur%2C%20so%20I%20put%20the%20Categorical%20Nominal%20Variable%20on%20the%20Y-axis%20and%20datetime%20on%20the%20X-axis.%26nbsp%3B%20For%20the%20purposes%20of%20this%20analysis%2C%20I%20choose%20to%20split%20each%20SN%20by%20Page.%26nbsp%3B%20When%20I%20do%20this%2C%20all%20Pages%20show%20all%20levels%20of%20%22Y%22%20on%20the%20Y-axis.%26nbsp%3B%20I%20only%20want%20to%20show%20the%20levels%20applicable%20to%20each%20SN%20on%20each%20Page.%26nbsp%3B%20Is%20there%20a%20way%20to%20exclude%20levels%20on%20specific%20Pages%20that%20don't%20exist%20for%20that%20group%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ashwint27_1-1722004107711.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ashwint27_1-1722004107711.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ashwint27_1-1722004107711.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22ashwint27_1-1722004107711.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66549iEACA65DC2654BF48%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ashwint27_1-1722004107711.png%22%20alt%3D%22ashwint27_1-1722004107711.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775809%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EBasic%20Data%20Analysis%20and%20Modeling%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Exploration%20and%20Visualization%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776863%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20Builder-Hide%20Categorical%20Nominal%20Levels%20on%20Y-axis%20not%20used%20in%20specific%20Pages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776863%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EIf%20you%20run%20Graph%20Builder%20and%20use%20the%20Dialog%20to%20enter%20the%20specifications%20for%20the%20graph%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_0-1722049532469.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1722049532469.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_0-1722049532469.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66561iF9C02F604FEB6D2D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_0-1722049532469.png%22%20alt%3D%22txnelson_0-1722049532469.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20then%20use%20the%20By%20selection%20instead%20of%20the%20Page%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_1-1722049716766.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1722049716766.png%22%20style%3D%22width%3A%20299px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_1-1722049716766.png%22%20style%3D%22width%3A%20299px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66562i1F6A3347ADC551A3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22txnelson_1-1722049716766.png%22%20alt%3D%22txnelson_1-1722049716766.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIt%20will%20treat%20each%20level%20of%20the%20By%20grouping%20as%20an%20independent%20graph.%26nbsp%3B%20%26nbsp%3BIn%20my%20example%2C%20I%20deleted%20all%20rows%20for%2012%20year%20old%20females%20from%20the%20data%20table%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22txnelson_2-1722049875433.png%22%20style%3D%22width%3A%20757px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1722049875433.png%22%20style%3D%22width%3A%20757px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22txnelson_2-1722049875433.png%22%20style%3D%22width%3A%20757px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66563i6F9253F6BF0CE109%2Fimage-dimensions%2F757x769%3Fv%3Dv2%22%20width%3D%22757%22%20height%3D%22769%22%20role%3D%22button%22%20title%3D%22txnelson_2-1722049875433.png%22%20alt%3D%22txnelson_2-1722049875433.png%22%20%2F%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-776877%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Graph%20Builder-Hide%20Categorical%20Nominal%20Levels%20on%20Y-axis%20not%20used%20in%20specific%20Pages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776877%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EA%20similar%20issue%20which%20I%20face%20very%20often%3A%3CBR%20%2F%3Etoo%20many%20labels%20on%20a%20x%20axis%20when%20using%20X%20group%20-%20or%20too%20many%20labels%20on%20a%20y%20axis%20when%20using%20Y%20group.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16391%22%20target%3D%22_blank%22%3E%40shampton82%3C%2FA%3E%26nbsp%3Bpointed%20out%20that%20%22page%22%26nbsp%3B%26nbsp%3Bcould%20be%20THE%20solution%20-%20with%20it's%20ability%20to%20have%20non-linked%20axes%20settings%3A%20%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%2Fidc-p%2F766540%2Fhighlight%2Ftrue%23M5623%22%20target%3D%22_blank%22%3Edirect%20Link%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1722062765827.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1722062765827.png%22%20style%3D%22width%3A%20371px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66565i2B432AABC0E8FFE1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1722062765827.png%22%20alt%3D%22hogi_0-1722062765827.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EUnfortunately%2C%20the%20setting%20is%20ignored%20for%20categorical%20values%20%3A%20(%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Erelated%20entry%20in%20the%20wish%20list%3A%3C%2FP%3E%3CP%3E%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%20%20restrict%20the%20values%20on%20the%20axis%20to%20the%20respective%20group%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
ashwint27
Level III

Graph Builder-Hide Categorical Nominal Levels on Y-axis not used in specific Pages

I have a data table that has a datetime column modelled as numeric-continuous.  I have various Serial Numbers ("SN", Categorical-Nominal) in another column, along with another Categorical-Nominal column, we can call "Y".  I want to see when certain "Y" events occur, so I put the Categorical Nominal Variable on the Y-axis and datetime on the X-axis.  For the purposes of this analysis, I choose to split each SN by Page.  When I do this, all Pages show all levels of "Y" on the Y-axis.  I only want to show the levels applicable to each SN on each Page.  Is there a way to exclude levels on specific Pages that don't exist for that group?

 

 

ashwint27_1-1722004107711.png

 

2 REPLIES 2
txnelson
Super User

Re: Graph Builder-Hide Categorical Nominal Levels on Y-axis not used in specific Pages

If you run Graph Builder and use the Dialog to enter the specifications for the graph

txnelson_0-1722049532469.png

and then use the By selection instead of the Page

txnelson_1-1722049716766.png

It will treat each level of the By grouping as an independent graph.   In my example, I deleted all rows for 12 year old females from the data table

txnelson_2-1722049875433.png

 

Jim
hogi
Level XII

Re: Graph Builder-Hide Categorical Nominal Levels on Y-axis not used in specific Pages

A similar issue which I face very often:
too many labels on a x axis when using X group - or too many labels on a y axis when using Y group.

 

@shampton82 pointed out that "page"  could be THE solution - with it's ability to have non-linked axes settings: direct Link

hogi_0-1722062765827.png

Unfortunately, the setting is ignored for categorical values : (

 

related entry in the wish list:

🙏 X group: restrict the values on the axis to the respective group