Use order of the first axis in control charts

[#1]

Hello,

I'm doing a control chart (see attached table script) where I display my values ​​('Value') in a specific order ('Order'). 'Order' is my subgroup. But I'd like to add a label to the axis, for example, 'Quarter - Year'. The problem is that this changes the data order. I'd like to use the order specified in the first subgroup, but keep 'Quarter Year' displayed at the bottom. How can I do this?

I know I could customize the order of my Quarter Year column, but within the same quarter, that doesn't guarantee the correct order.

Expected (right order)

Obtained (wrong order)

[#2]

Which version of JMP are you using? JMP 19 made some changes to the default behavior, and the script on the data table supplied looks (I think?) how you want without any changes:

[#3]

Hi @SophieCuvillier ,

What version of JMP are you using? I just tried your script on v19.0.1. and it came out in the right order:

Thanks,
Ben

[#4]

It is JMP 18.1.1 , I can't use JMP 19 yet as the client had not migrated to the latest version yet

[#5]

These work at least with JMP18.

Try adding Vale Order column property to your QUARTER-YEAR (Q3/Q4-2024 are in wrong location)

Other option (which I would not suggest) is to add second Order column to your X-axis and then hide it

 

[#6]

Hello,

Thank you for your answer!  The problem is that I've noticed that even if I add a 'value order' property column to the QUARTER YEAR axis, it doesn't necessarily sort the values ​​within the same quarter in the correct order; it doesn't always take into account the order below (even if the axis below has also a column property).

So I was interested in your second option, but in JSL I can't achieve to add the same value to a duplicate axis; it automatically deletes it. I can only do it by dragging and dropping.

[#7]

Maybe you have to add value order to both of the columns?

If it will automatically remove it, create "temporary" column which copies the values of the column you wish to duplicate and then use that as x-axis