913158_en-US

liliconcom

Use order of the first axis in control charts

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)

 

 

 

Automation and ScriptingData Exploration and VisualizationRe: Use order of the first axis in control charts

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:

 

Re: Use order of the first axis in control charts

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

Re: Use order of the first axis in control charts

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

Re: Use order of the first axis in control charts

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

 

 

 

 

Re: Use order of the first axis in control charts

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.

Re: Use order of the first axis in control charts

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

Re: Use order of the first axis in control charts

Hello it was a mistake on my side in my data (not the ones from reprex), if both columns havee order property it works thank you