I have a simple bar chart, per below (# of promos is X-axis, # of views is Y-axis). In JMP 11, what would be the easiest way to combine some of the bars so that in the graph I can see the average views for 0 promos, 1 promo, 2 promos, and 3+ promos? Thanks.
The fastest way is to create a new column using Cols -> Recode to combine the levels. Then use this new column in your graph.
Thanks for the quick response, Jeff - but nothing seems to happen when I recode:
Nothing happens when I try changing the values in the "new value" area and clicking OK. Not sure what I'm missing here, whether I'm inputting incorrect data into the "New Value" box or if I'm supposed to select a formula column (tried but didn't have luck with that, either) but it should be pretty simple.
Sorry about that. I forgot that Recode doesn't really like to work with Numeric columns. Change the Data Type of your # of promos column to Character and then try. Then do it to a New Column.
Let us know if still have trouble.
Ah, good to know. The solution worked perfectly. Thanks Jeff!
Another option might be to use Col > Utilities > Make Binning Formula. Or the interactive binning formula add-in (https://community.jmp.com/docs/DOC-6237) And then using the binning formula column that is generated in your graph.