Ordering categories for a bar chart of sums of values

[#1]

Dear JMP help community,

I have a dataset consisting of expenses grouped within many different categories (maintenance, salaries etc.). Within each category there are many rows of expenses, e.g. in maintenance I have rows for painting expenses, carpentry, electrical services etc.

I can create a treemap to show the relative size of each expense group, but would prefer an bar chart with one bar for each category, ordered by total expense within each category. This last part I can't seem to get to work. Ordering bars by the expense value seems to order by number of expense posts within each category, rather than putting the bar with the highest sum of expenses first.

Has anyone solved this? Thanks in advance for your input!

(I'm on JMP 18.2.0)

[#2 · Accepted solution]

When you have graph like this

You can order X-axis by right clicking on it

Select Other, pick your Y-axis column

Right click again and change ordering statistic

And finally change Order By (if necessary)

[#3]

Hi @ANVAR,

Welcome in the Community !

I think there might be an easy fix for your situation :

• Create a formula column of total sum /expense by category : 

  Col Sum(:expense, :category)

• Then create your graph, and on the x-axis for category, right-click and select "Order by", "Other" and select your new formula column sum by category. This way, it will order the categories by the total expense for each category, in ascending order (but you can change it, right-clicking, order by, and change the ordering with the same column in "descending").

You can provide a toy dataset if you want to have detailed explanations about the actions to perform.
Hope this answer will help you,

[#4]

Thank you for your fast and thorough answers, both. It worked like a charm. Much appreciated!

And thank you for your kind welcome to the JMP community.