cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
%3CLINGO-SUB%20id%3D%22lingo-sub-195334%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3Eforcer%20tous%20les%20niveaux%20d'histogramme%20sur%20le%20graphique%20%C3%A0%20barres%2C%20m%C3%AAme%20si%20nombre%20%3D%200%26nbsp%3B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195334%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBonjour%20-%20je%20cr%C3%A9e%20plusieurs%20histogrammes%20avec%209%20niveaux%20cat%C3%A9goriels%20possibles%20-%20j'aimerais%20que%20les%209%20niveaux%20s'affichent%20sur%20l'axe%2C%20m%C3%AAme%20si%20le%20nombre%20de%20fr%C3%A9quences%20est%20nul%20pour%20un%20bac%20sp%C3%A9cifique%20sur%20un%20histogramme%20sp%C3%A9cifique...%20Existe-t-il%20un%20moyen%20de%20forcer%20l'affichage%20des%20comptes%20nuls%20sur%20l'axe%20du%20graphique%20(par%20exemple%2C%20le%20bac%20est%20inclus%20sur%20l'axe%2C%20mais%20il%20n'y%20a%20pas%20de%20barre%20puisque%20le%20nombre%20%3D%200)%26nbsp%3B%3F%20Je%20pense%20que%20le%20fait%20d'avoir%20tous%20les%20niveaux%20sur%20chaque%20graphique%20permettra%20au%20lecteur%20de%20comparer%20plus%20facilement%20les%20graphiques.%20pour%20le%20moment%2C%20j'ai%20essay%C3%A9%20d'utiliser%20l'ic%C3%B4ne%20de%20distribution%2C%20mais%20chaque%20histogramme%20qu'elle%20cr%C3%A9e%20a%20un%20assortiment%20diff%C3%A9rent%20de%20niveaux%20cat%C3%A9goriels.%20J'utilise%20JMP%2013.2.1%3C%2FP%3E%3CP%3Emerci%20d'avance%20pour%20toutes%20id%C3%A9es%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-195337%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%20%3A%20forcer%20tous%20les%20niveaux%20d'histogramme%20sur%20le%20graphique%20%C3%A0%20barres%2C%20m%C3%AAme%20si%20count%20%3D%200%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195337%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Emerci!%20vos%20conseils%20ont%20fait%20l'affaire%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-195336%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%20%3A%20forcer%20tous%20les%20niveaux%20d'histogramme%20sur%20le%20graphique%20%C3%A0%20barres%2C%20m%C3%AAme%20si%20count%20%3D%200%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195336%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJe%20suppose%20que%20vous%20utilisez%20Graph%20Builder.%20Il%20existe%20peut-%C3%AAtre%20de%20meilleures%20fa%C3%A7ons%20de%20proc%C3%A9der%2C%20mais%20cela%20devrait%20fonctionner.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJe%20recommanderais%20d'utiliser%20la%20propri%C3%A9t%C3%A9%20Value%20Ordering%20afin%20que%20chaque%20graphique%20ait%20le%20m%C3%AAme%20ordre%20sur%20l'axe%20des%20x.%3C%2FP%3E%0A%3CP%3EAjoutez%20ensuite%20une%20colonne%20compos%C3%A9e%20uniquement%20de%201%20au%20tableau%2C%20appelez%20cette%20colonne%20Freq.%20utilisez%20un%20r%C3%B4le%20pr%C3%A9s%C3%A9lectionn%C3%A9%20de%20Fr%C3%A9quence%20pour%20cette%20colonne.%3C%2FP%3E%0A%3CP%3ED%C3%A9sormais%2C%20chaque%20fois%20que%20vous%20avez%20un%20graphique%20dans%20lequel%20un%20niveau%20manque%2C%20ajoutez%20le%20niveau%2C%20mais%20mettez%20un%200%20dans%20la%20colonne%20Freq.%20Cela%20devrait%20le%20faire%20appara%C3%AEtre%20sur%20le%20graphique.%3C%2FP%3E%0A%3CP%3EJ'ai%20inclus%20un%20exemple%20de%20fichier%20avec%20un%20exemple%20o%C3%B9%20le%20niveau%20D%20est%20manquant.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774131%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20forcer%20tous%20les%20niveaux%20d'histogramme%20sur%20le%20graphique%20%C3%A0%20barres%2C%20m%C3%AAme%20si%20count%20%3D%200%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774131%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FColumn-Property-Inclusive-Values%2Fm-p%2F730865%23U730865%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%20Propri%C3%A9t%C3%A9%20de%20colonne%26nbsp%3B%3A%20valeurs%20inclusives%3C%2FA%3E%20%3C%2FP%3E%3CP%3Er%C3%A9soudra%20ce%20probl%C3%A8me.%3CBR%20%2F%3E%3CBR%20%2F%3E%20compris%3F%3CBR%20%2F%3E%20quel%20est%20le%20meilleur%20mot%20pour%20d%C3%A9crire%20cette%20fonctionnalit%C3%A9%26nbsp%3B%3F%3CBR%20%2F%3E%20des%20%C2%AB%20valeurs%20forc%C3%A9es%20%C2%BB%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
ksteinmann
Level I

force all histogram levels on bar graph, even if count = 0?

Hi - i am making mulitple histogram graphs with 9 categorical levels possible  - i would like all 9 levels to show on the axis, even if the frequency count is zero for a specific bin on a specific histogram... Is there a way to force zero counts to show on the graph axis (for example, the bin in included on the axis, but there is no bar since count = 0)? I think having all levels on each graph will make it easier for the reader to compare across graphs. right now i have tried using the distribution icon, but each histogram it creates has a different assortment of categorical levels. I am using JMP 13.2.1

thanks in advance for any ideas

1 ACCEPTED SOLUTION

Accepted Solutions

Re: force all histogram levels on bar graph, even if count = 0?

I assume you are using Graph Builder. There may be better ways to do this, but this should work.

 

I would recommend using the Value Ordering property so that each graph will have the same order on the x-axis.

Then add a column of all 1's to the table, call this column Freq. use a pre-selected role of Frequency for this column.

Now whenever you have a graph where a level is missing, add the level, but put a 0 in the Freq column. This should make it appear on the graph.

I have included a sample file with an example where level D is missing.

Dan Obermiller

View solution in original post

3 REPLIES 3

Re: force all histogram levels on bar graph, even if count = 0?

I assume you are using Graph Builder. There may be better ways to do this, but this should work.

 

I would recommend using the Value Ordering property so that each graph will have the same order on the x-axis.

Then add a column of all 1's to the table, call this column Freq. use a pre-selected role of Frequency for this column.

Now whenever you have a graph where a level is missing, add the level, but put a 0 in the Freq column. This should make it appear on the graph.

I have included a sample file with an example where level D is missing.

Dan Obermiller
ksteinmann
Level I

Re: force all histogram levels on bar graph, even if count = 0?

thank you! your advice did the trick!

hogi
Level XII

Re: force all histogram levels on bar graph, even if count = 0?

🙏 Column Property: Inclusive Values 

will fix this issue.

inclusive?
what's the best word to describe this functionality?
"forced values"?