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-195334%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3Ecount%20%3D%200%20%EC%9D%B8%20%EA%B2%BD%EC%9A%B0%EC%97%90%EB%8F%84%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%AA%A8%EB%93%A0%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EC%A0%81%EC%9A%A9%20%ED%95%98%EC%8B%9C%EA%B2%A0%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195334%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94%20-%20%EB%82%98%EB%8A%94%20%EA%B0%80%EB%8A%A5%ED%95%9C%209%20%EA%B0%9C%EC%9D%98%20%EB%B2%94%EC%A3%BC%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EA%B0%80%EC%A7%84%20%EB%8B%A4%EC%A4%91%20%ED%9E%88%EC%8A%A4%ED%86%A0%EA%B7%B8%EB%9E%A8%20%EA%B7%B8%EB%9E%98%ED%94%84%EB%A5%BC%20%EC%9E%91%EC%84%B1%20%EC%A4%91%EC%9E%85%EB%8B%88%EB%8B%A4%20-%20%ED%8A%B9%EC%A0%95%20%ED%9E%88%EC%8A%A4%ED%86%A0%EA%B7%B8%EB%9E%A8%EC%9D%98%20%ED%8A%B9%EC%A0%95%20%EB%B9%88%EC%97%90%20%EB%8C%80%ED%95%B4%20%EB%B9%88%EB%8F%84%20%EC%88%98%EA%B0%80%200%20%EC%9D%B8%20%EA%B2%BD%EC%9A%B0%EC%97%90%EB%8F%84%20%EC%B6%95%EC%97%90%20%EB%AA%A8%EB%93%A0%209%20%EA%B0%9C%EC%9D%98%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%ED%91%9C%EC%8B%9C%ED%95%98%EA%B3%A0%20%EC%8B%B6%EC%8A%B5%EB%8B%88%EB%8B%A4%20...%20%EC%A0%9C%EB%A1%9C%20%EC%B9%B4%EC%9A%B4%ED%8A%B8%EB%A5%BC%20%EA%B7%B8%EB%9E%98%ED%94%84%20%EC%B6%95%EC%97%90%20%ED%91%9C%EC%8B%9C%ED%95%98%EB%8F%84%EB%A1%9D%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%20(%EC%98%88%20%3A%20%EC%B6%95%EC%97%90%20%ED%8F%AC%ED%95%A8%20%EB%90%9C%20%EB%B9%88%2C%20%EA%B7%B8%EB%9F%AC%EB%82%98%20count%20%3D%200%EB%B6%80%ED%84%B0%20%EB%A7%89%EB%8C%80%EA%B0%80%20%EC%97%86%EC%9D%8C)%3F%20%EA%B0%81%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%AA%A8%EB%93%A0%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EC%A0%81%EC%9A%A9%ED%95%98%EB%A9%B4%20%EB%8F%85%EC%9E%90%EA%B0%80%20%EA%B7%B8%EB%9E%98%ED%94%84%EB%A5%BC%20%EB%B9%84%EA%B5%90%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%B4%20%EB%8D%94%20%EC%89%AC%EC%9B%8C%20%EC%A7%88%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%20%EC%A7%80%EA%B8%88%EC%9D%80%20%EB%B0%B0%ED%8F%AC%20%EC%95%84%EC%9D%B4%EC%BD%98%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%8B%9C%EB%8F%84%ED%96%88%EC%A7%80%EB%A7%8C%20%EA%B0%81%20%ED%9E%88%EC%8A%A4%ED%86%A0%EA%B7%B8%EB%9E%A8%EC%9D%80%20%EC%B9%B4%ED%85%8C%EA%B3%A0%EB%A6%AC%20%EB%B3%84%20%EB%B6%84%EB%A5%98%EA%B0%80%20%EB%8B%A4%EB%A6%85%EB%8B%88%EB%8B%A4.%20JMP%2013.2.1%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EA%B3%A0%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EB%AF%B8%EB%A6%AC%20%EC%95%84%EC%9D%B4%EB%94%94%EC%96%B4%EB%A5%BC%20%EC%A3%BC%EC%85%94%EC%84%9C%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4.%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%20count%20%3D%200%20%EC%9D%B8%20%EA%B2%BD%EC%9A%B0%EC%97%90%EB%8F%84%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%AA%A8%EB%93%A0%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EC%A0%81%EC%9A%A9%20%ED%95%98%EC%8B%9C%EA%B2%A0%EC%8A%B5%EB%8B%88%EA%B9%8C%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%EA%B3%A0%EB%A7%99%EC%8A%B5%EB%8B%88%EB%8B%A4!%20%EB%8B%B9%EC%8B%A0%EC%9D%98%20%EC%B6%A9%EA%B3%A0%EA%B0%80%20%ED%8A%B8%EB%A6%AD%EC%9D%84%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4!%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%20count%20%3D%200%20%EC%9D%B8%20%EA%B2%BD%EC%9A%B0%EC%97%90%EB%8F%84%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%AA%A8%EB%93%A0%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EC%A0%81%EC%9A%A9%20%ED%95%98%EC%8B%9C%EA%B2%A0%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-195336%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EA%B7%B8%EB%9E%98%ED%94%84%20%EB%B9%8C%EB%8D%94%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EA%B3%A0%20%EC%9E%88%EB%8B%A4%EA%B3%A0%20%EA%B0%80%EC%A0%95%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EB%A5%BC%20%EC%88%98%ED%96%89%ED%95%98%EB%8A%94%20%EB%8D%94%20%EC%A2%8B%EC%9D%80%20%EB%B0%A9%EB%B2%95%EC%9D%B4%EC%9E%88%EC%9D%84%20%EC%88%98%20%EC%9E%88%EC%A7%80%EB%A7%8C%20%EC%9D%B4%EA%B2%83%EC%9D%B4%20%ED%9A%A8%EA%B3%BC%EA%B0%80%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%EA%B0%92%20%EC%88%9C%EC%84%9C%20%EC%A7%80%EC%A0%95%20%EC%86%8D%EC%84%B1%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EA%B0%81%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%9D%98%20x%20%EC%B6%95%20%EC%A0%95%EB%A0%AC%20%EC%88%9C%EC%84%9C%EA%B0%80%20%EA%B0%99%EB%8F%84%EB%A1%9D%ED%95%98%EB%8A%94%20%EA%B2%83%EC%9D%B4%20%EC%A2%8B%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EA%B7%B8%EB%9F%B0%20%EB%8B%A4%EC%9D%8C%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EB%AA%A8%EB%91%90%201%EC%9D%98%20%EC%97%B4%EC%9D%84%20%EC%B6%94%EA%B0%80%ED%95%98%EA%B3%A0%EC%9D%B4%20%EC%97%B4%EC%9D%84%20Freq%EB%9D%BC%EA%B3%A0%20%EB%B6%80%EB%A6%85%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%20%EC%97%B4%EC%97%90%20%EB%AF%B8%EB%A6%AC%20%EC%A7%80%EC%A0%95%EB%90%9C%20%EB%B9%88%EB%8F%84%20%EC%97%AD%ED%95%A0%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%8B%AD%EC%8B%9C%EC%98%A4.%3C%2FP%3E%0A%3CP%3E%EC%9D%B4%EC%A0%9C%20%EB%A0%88%EB%B2%A8%EC%9D%B4%EC%97%86%EB%8A%94%20%EA%B7%B8%EB%9E%98%ED%94%84%EA%B0%80%EC%9E%88%EC%9D%84%20%EB%95%8C%EB%A7%88%EB%8B%A4%20%EB%A0%88%EB%B2%A8%EC%9D%84%20%EC%B6%94%EA%B0%80%ED%95%98%EB%90%98%20Freq%20%EC%97%B4%EC%97%90%200%EC%9D%84%20%EC%9E%85%EB%A0%A5%ED%95%98%EC%8B%AD%EC%8B%9C%EC%98%A4.%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%82%98%ED%83%80%EB%82%98%EC%95%BC%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%EB%A0%88%EB%B2%A8%20D%EA%B0%80%EC%97%86%EB%8A%94%20%EC%98%88%EC%A0%9C%EC%99%80%20%ED%95%A8%EA%BB%98%20%EC%83%98%ED%94%8C%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%ED%8F%AC%ED%95%A8%20%EC%8B%9C%EC%BC%B0%EC%8A%B5%EB%8B%88%EB%8B%A4.%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%EA%B0%9C%EC%88%98%20%3D%200%EC%9D%B8%20%EA%B2%BD%EC%9A%B0%EC%97%90%EB%8F%84%20%EB%A7%89%EB%8C%80%20%EA%B7%B8%EB%9E%98%ED%94%84%EC%97%90%20%EB%AA%A8%EB%93%A0%20%ED%9E%88%EC%8A%A4%ED%86%A0%EA%B7%B8%EB%9E%A8%20%EC%88%98%EC%A4%80%EC%9D%84%20%EA%B0%95%EC%A0%9C%20%EC%A0%81%EC%9A%A9%ED%95%98%EC%8B%9C%EA%B2%A0%EC%8A%B5%EB%8B%88%EA%B9%8C%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%20%EC%97%B4%20%EC%86%8D%EC%84%B1%3A%20%ED%8F%AC%ED%95%A8%20%EA%B0%92%3C%2FA%3E%20%3C%2FP%3E%3CP%3E%EC%9D%B4%20%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%ED%95%B4%EA%B2%B0%ED%95%A0%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%3CBR%20%2F%3E%3CBR%20%2F%3E%20%ED%8F%AC%ED%95%A8%ED%95%9C%3F%3CBR%20%2F%3E%20%EC%9D%B4%20%EA%B8%B0%EB%8A%A5%EC%9D%84%20%EA%B0%80%EC%9E%A5%20%EC%9E%98%20%EC%84%A4%EB%AA%85%ED%95%98%EB%8A%94%20%EB%8B%A8%EC%96%B4%EB%8A%94%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3CBR%20%2F%3E%20%22%EA%B0%95%EC%9A%94%EB%90%9C%20%EA%B0%80%EC%B9%98%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"?