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%3Eforzar%20todos%20los%20niveles%20de%20histograma%20en%20el%20gr%C3%A1fico%20de%20barras%2C%20incluso%20si%20cuenta%20%3D%200%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195334%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%3A%20estoy%20haciendo%20m%C3%BAltiples%20gr%C3%A1ficos%20de%20histogramas%20con%209%20niveles%20categ%C3%B3ricos%20posibles%3A%20me%20gustar%C3%ADa%20que%20todos%20los%209%20niveles%20se%20muestren%20en%20el%20eje%2C%20incluso%20si%20el%20recuento%20de%20frecuencia%20es%20cero%20para%20una%20ubicaci%C3%B3n%20espec%C3%ADfica%20en%20un%20histograma%20espec%C3%ADfico%20...%20%C2%BFHay%20alguna%20forma%20de%20forzar%20que%20se%20muestren%20cero%20conteos%20en%20el%20eje%20del%20gr%C3%A1fico%20(por%20ejemplo%2C%20el%20contenedor%20incluido%20en%20el%20eje%2C%20pero%20no%20hay%20una%20barra%20desde%20el%20conteo%20%3D%200)%3F%20Creo%20que%20tener%20todos%20los%20niveles%20en%20cada%20gr%C3%A1fico%20facilitar%C3%A1%20al%20lector%20la%20comparaci%C3%B3n%20entre%20los%20gr%C3%A1ficos.%20En%20este%20momento%20he%20intentado%20usar%20el%20%C3%ADcono%20de%20distribuci%C3%B3n%2C%20pero%20cada%20histograma%20que%20crea%20tiene%20una%20variedad%20diferente%20de%20niveles%20categ%C3%B3ricos.%20Estoy%20usando%20JMP%2013.2.1%3C%2FP%3E%3CP%3EGracias%20de%20antemano%20por%20cualquier%20idea%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%3A%20forzar%20todos%20los%20niveles%20de%20histograma%20en%20el%20gr%C3%A1fico%20de%20barras%2C%20incluso%20si%20cuenta%20%3D%200%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195337%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%C2%A1gracias!%20Tu%20consejo%20hizo%20el%20truco!%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%3A%20forzar%20todos%20los%20niveles%20de%20histograma%20en%20el%20gr%C3%A1fico%20de%20barras%2C%20incluso%20si%20cuenta%20%3D%200%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195336%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESupongo%20que%20est%C3%A1%20utilizando%20Graph%20Builder.%20Puede%20haber%20mejores%20formas%20de%20hacer%20esto%2C%20pero%20esto%20deber%C3%ADa%20funcionar.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERecomendar%C3%ADa%20usar%20la%20propiedad%20Ordenamiento%20de%20valores%20para%20que%20cada%20gr%C3%A1fico%20tenga%20el%20mismo%20orden%20en%20el%20eje%20x.%3C%2FP%3E%0A%3CP%3ELuego%20agregue%20una%20columna%20de%20todos%20los%201%20a%20la%20tabla%2C%20llame%20a%20esta%20columna%20Freq.%20use%20un%20rol%20de%20Frecuencia%20preseleccionado%20para%20esta%20columna.%3C%2FP%3E%0A%3CP%3EAhora%2C%20cada%20vez%20que%20tenga%20un%20gr%C3%A1fico%20donde%20falta%20un%20nivel%2C%20agregue%20el%20nivel%2C%20pero%20coloque%20un%200%20en%20la%20columna%20Frecuencia.%20Esto%20deber%C3%ADa%20hacer%20que%20aparezca%20en%20el%20gr%C3%A1fico.%3C%2FP%3E%0A%3CP%3EHe%20incluido%20un%20archivo%20de%20muestra%20con%20un%20ejemplo%20donde%20falta%20el%20nivel%20D.%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%3A%20%C2%BFforzar%20todos%20los%20niveles%20del%20histograma%20en%20el%20gr%C3%A1fico%20de%20barras%2C%20incluso%20si%20cuenta%20%3D%200%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%20Propiedad%20de%20columna%3A%20valores%20inclusivos%3C%2FA%3E%20%3C%2FP%3E%3CP%3Esolucionar%C3%A1%20este%20problema.%3CBR%20%2F%3E%3CBR%20%2F%3E%20%C2%BFinclusivo%3F%3CBR%20%2F%3E%20%C2%BFCu%C3%A1l%20es%20la%20mejor%20palabra%20para%20describir%20esta%20funcionalidad%3F%3CBR%20%2F%3E%20%C2%BF%22valores%20forzados%22%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"?