Interactive charting

[MHS]

Hello Community!

Quick question on the charting tool.  I am attempting to display a bar graph in a specific order that is not alphabetically ordered or is not sorted by count.  Does anyone happen to know of a tool or statement that I can use to display this data in a custom fashion?

Thanks, 

Matt

[tsturge · Accepted solution]

You may want to use a formula tool with an if / then statement that creates a "sortable" field before you chart.  I don't know your data but using a common Geography example IF Region = 'Northeast' THEN 'A' ELSE IF Region = 'West' then 'B' etc.  The new field would contain A or B in it.

Similar to this example and taking it one step further if your data permits you can prefix our Region values like 'A: Northeast' or 'B: West' to force the proper sort

[MHS]

Thank you much for the help!

Didn't think of adding a field to sort the values by.

Matt