Change order of returned results in Bar Chart

[peterw]

Hi all,

I'm hoping this may be a simple thing that I'm overlooking. I have a very simple bar chart report (reports against the HR case table and counts the records created by state):

What I need to do is change the order in which the states display in the report. The requirement is to display them in the order:

New, Work in Progress, On Hold, Resolved, Closed Complete.

Is there a simple way in which to do this. Having investigated I can see several users referring to JFreeChart scripts. In an attempt to avoid this can anyone advise of another way to do this?

Thanks in advance,

Peter

[richard_selby]

In Geneva, look for the Add Sort Field button to the right of Add Filter Condition. When you click it, you can choose fields to sort by as well as the sort order (either 'a to z' or 'z to a'). For a choice filed, it looks at the underlying values rather than the label.   The screen shot shows a report ordering problems by priority High, Medium, Low. The underlying values are 2,3,4 so the order is alpahbetical 'a to z'.

[chennessy]

Richard,

Not sure how you got that to work... I have followed your instructions, created values of 1-5, but my chart is still listing the bars alphabetically by the label rather than the value.   Anything I might be missing?     I see it's been a while since this answer was posted but no one else seems to be having this issue.         Thanks!      

[Eric Manning]

You are not wrong. Years later and this still doesn't work.

[Pablo1]

Hi, I do see the Add Sort button in my Utah instane. I have seen where the button disappears in an already saved report. Might need to delete and re-add your filters in the report to see the Add Sort button.