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

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

ksteinmann — Mon, 29 Apr 2019 18:18:37 GMT

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

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

Dan_Obermiller — Mon, 29 Apr 2019 19:01:32 GMT

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.

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

ksteinmann — Mon, 29 Apr 2019 21:02:20 GMT

thank you! your advice did the trick!

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

hogi — Fri, 19 Jul 2024 15:26:29 GMT

will fix this issue.

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