Can you sort a stacked bar chart in JRS so it is sorted by cumulative totals?
I have a work item that we use to review documents. There is a document number in each of these work items. I created a bar chart in JRS and the work items are grouped by document number. It sorts High to Low correctly putting the document number with the most work items first, second most listed second, etc. (longest bar to shortest bar)
When I used a stacked bar chart, I am still grouping them by document number and then a subgroup of status, so the bar for each document contains pieces of the bar for each different status for these documents. I would still like to sort it High to Low, so the document with the most work items is first, second most items is second, etc. The sort feature does not work here. For all I can tell it randomly sorts them and when I change it from "High to Low" to "Low to High" there is no change in the order of the bar chart.
Does anybody know how to get these to sort by the overall totals for each document? So visually it will have longest bar sorted down to shortest bar.
Accepted answer
Looks like this already an existing enhancement request so I don't think it is possible yet. Please add your comments or your +1 to get it more attention: https://jazz.net/jazz/web/projects/Jazz%20Reporting%20Service#action=com.ibm.team.workitem.viewWorkItem&id=370875
Comments
Thank you, Rosa! I have used the voting feature before, but I don't see that as an option on this Enhancement. Is this something that will be added to it soon so I can vote?
Thank you, Rosa! I have used the voting feature before, but I don't see that as an option on this Enhancement. Is this something that will be added to it soon so I can vote?
Janet,
the voting feature was just added. please try it and add your vote for this enhancement.
Thanks, Rosa! I have voted for it.
This is currently slated for 6.0.3 and some nice progress should be visible soon.