Is it possible to define the order columns are shown on Charts

[simonbourne]

I have a chart that shows the number of Incidents by State.   It shows them in order of decreasing number but I want it to reflect Open, On Hold and Resolved...... in that order.

Is it possible to define the order?

[Dennis R · Accepted solution]

Unfortunately, I don't know of any way to do this. You can order it from highest number to lowest number (as you have them ordered in your screenshot) but not specifying an order by field, or you can order them by the field you're grouping by, which would give them to you as [On Hold, Open, Resolved], or you can order them by that field in descending order, which would give you [Resolved, Open, On Hold]. But I don't know of any way to specify an arbitrary order of the columns.

One workaround that might be kind of cheesy would be rename the labels of the choices to something like [0 Open, 1 On Hold, 2 Resolved], but of course, that would change the labels everywhere else, which likely would rule it out as an option.

Wish I could be more help,

--Dennis R

[simonbourne]

Thanks.  I thought I was missing some trick, but if it can't be done...