topic Re: How to show the actual range in the level values in Graph Builder? in Discussions

How to show the actual range in the level values in Graph Builder?

JaneYang — Sun, 11 Jun 2023 11:19:56 GMT

Hi,

In the attached plot, the property of column "ChannelNumber" is Numeric/Continuous. I found it confusing in the grouped values at the top. "0-4" actually includes 0-3, as shown at the bottom; "4-8" actualy includes 4-7. It seems the range at the top always has overlapping values between adjacent levels. What can I do to make this overlap go away (i.e. I want it to show "0-3", "4-7","8-11" at the top)? Thank you very much...

Re: How to show the actual range in the level values in Graph Builder?

frank_wang — Mon, 29 Nov 2021 05:23:38 GMT

Hi Jane

增加一个新的列，将你原先的信道归纳到这3个分类里。（0~3，4~7，8~11）

用新增的列作为X group即可实现你的需求。

Re: How to show the actual range in the level values in Graph Builder?

JaneYang — Mon, 29 Nov 2021 05:30:27 GMT

Thank you Frank. I wonder if there is a way other than adding a new column...

Re: How to show the actual range in the level values in Graph Builder?

jthi — Mon, 29 Nov 2021 06:08:28 GMT

If you have JMP16, you could create Custom Range:

Or in this case it might be enough if you just change the Bin Label Style from Cutpoints red triangle in same Custom Levels menu.

Default:

Using Low to high - 1

Re: How to show the actual range in the level values in Graph Builder?

JaneYang — Mon, 29 Nov 2021 09:23:56 GMT

Thanks, but I am using JMP14. There is no "Custom Levels" option. The closest I can get it to add a Binning column:

Any other ideas please?

Re: How to show the actual range in the level values in Graph Builder?

Dan_Obermiller — Mon, 29 Nov 2021 14:01:11 GMT

Just wanted to point out that if the value is continuous, then what happens if you have a value of 3.9? What about 3.999999? The default is that the intervals are left inclusive. Mathematically it would be written as [0,4), [4,8), etc..

It sounds like you might want to consider the data as ordinal if the fractions are not possible.

Re: How to show the actual range in the level values in Graph Builder?

JaneYang — Tue, 30 Nov 2021 08:45:53 GMT

Thanks, Dan. I tried that too. This is what I got after setting it to ordinal:

Re: How to show the actual range in the level values in Graph Builder?

ian_jmp — Tue, 30 Nov 2021 09:27:10 GMT

Unfortunately, I don't have JMP 14 to hand to check - But if you right click on 'ChannelNumber' in the Graph Builder display immediately above, do you see some options that allow you to control the number of levels displayed?

Re: How to show the actual range in the level values in Graph Builder?

Dan_Obermiller — Tue, 30 Nov 2021 15:18:53 GMT

I do have version 14. If you right-click on the channel number, select Number of Levels. From your first example, that would be 12 levels. Not sure why yours defaulted to 3 levels as mine defaulted to all levels.

I made a simple example, and it looks like this (as a scatterplot rather than boxplot).

Re: How to show the actual range in the level values in Graph Builder?

JaneYang — Thu, 02 Dec 2021 00:16:10 GMT

Thanks Dan. I was trying to make the ChannelNumber into 3 equal groups, as in 0-3, 4-7, 8-11. Number of Levels to display was set to 3. My original question was how to make it show "0-3","4-7","8-11" at the top, instead of "0-4","4-8","8-11", without adding another column.

Re: How to show the actual range in the level values in Graph Builder?

hogi — Thu, 13 Apr 2023 14:46:25 GMT

What a wonderful feature: custom labels !

I tried to reproduce the steps in the screenshots with Jmp 17.1.0 - but once I change something in the binning scheme or the Bin Label Style, the displayed labels switch to "single number only" - independent of the Bin Label Style settings.

This is how it looks after pressing "OK" and opening the menu again:

Re: How to show the actual range in the level values in Graph Builder?

hogi — Sun, 16 Apr 2023 14:47:37 GMT

Jmp support confirmed that this is a known bug in Jmp 17.1 - th same if you try to use custom labels:

According to the settings on the left, it should be "low" and "high" but in the plot actually it is "64" and "100":

Re: How to show the actual range in the level values in Graph Builder?

hogi — Fri, 05 May 2023 14:40:11 GMT

Workaround at the moment:

"save" the user define binning as a Transform Column and use that column.

the disadvantage: the user loses the ability to adjust the settings via Right Click/ Custom Labels ...

Re: How to show the actual range in the level values in Graph Builder?

hogi — Thu, 14 Sep 2023 18:28:02 GMT

Seems to be fixed in Jmp 17.2
thanks :)