Reorder bars on chart, by value instead of alphabetical
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2022 12:16 PM
With a bar chart, when grouped by a field like "State". The bars will show in alphabetical order based on the label of the choice list options.
That said, I can't figure out what is currently driving the order. I want the sequence field on choice to drive the column order (or some other method).
The default order of the bars is not even aspherical, which is very confusing.
Default order: Complete, Draft, Ready, Requirements, Cancelled, WIP, RFT
Value order: 3, -6, 1, -4, 4, 2, -7
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2022 05:50 AM
By default it will sort the bars based on the number of records in each grouping. You can add a sort on the State field and it will then sort instead on the value of the state choice. I don't think there is a way, when using a choice field, to make it sort on the choice sequence or even the choice label instead of the choice value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-06-2022 06:01 AM
Hi Chad - Thanks for the comment. Maybe I am doing something wrong, but my Open INC by Assigned to orders the bars in alphabetical order by assigned to. Any ideas?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-01-2022 09:08 AM
Can you provide an XML export of your report so I can try it myself?
