nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sort Fit Y by X Graph by Mean value

Lovy_Singh

I am trying to sort the X-axis order of a fit Y by X graph using the value of the mean.

I was able to sort the Oneway Annova Table from highest mean (Healdsburg) to the lowest (Sacramento)

But I would like to show that graphically as well with Healdsburg on the left, and then as moving to the right the means decreasing until we are at the lowest mean (Sacramento).

This would be a nice way to see all the means in a visually appealing descending order.

Thank you,

lovy

sort.jpg

Accepted answers

Jordan_Hiller

Here's a hack: Use Graph Builder to change the column order before going into Fit Y by X.

Make the graph with City on X, Price on Y. Order the X Axis by Descending or Ascending Price. Then right-click on the axis and choose "Save Value Order." The Cities will be ordered by mean price when you go into Fit Y by X.

And I agree @Lovy_Singh , it would be nice to have this as a feature in Fit Y by X / Oneway.

All comments

karencopeland

Right click on the axis the select "Edit Value Order" to manually assign a custom order to your labels. Unlike graph builder, one-way (to the best of my knowledge) doesn't' support reordering based on a metric.

Jordan_Hiller

Here's a hack: Use Graph Builder to change the column order before going into Fit Y by X.

And I agree @Lovy_Singh , it would be nice to have this as a feature in Fit Y by X / Oneway.

Jed_Campbell

Wow, that's a great hack!

Dan_Obermiller

I LOVE @Jordan_Hiller 's hack. I too believe it should be in Fit Y by X. So much so that I wrote a script to do this back in 2007. I called it the "Super Pareto" chart. I have included the script here, but a few caveats:

The x-axis must be a character string (not just ordinal/nominal).
Since this was written so long ago (v7 or v8, probably), that there is an issue with reading a list into the Value Order column property (line 84 of the code). I don't have time to fix that right now, but maybe a scripter can update this and fix that issue.

There are some old commands that still work, but should probably be updated, like Dialog is used instead of New Window.

SuperParetoScript.jsl