Is there a way to sort by count for a work item query?
2 answers
You could use the Work Item Statistics dashboard viewlet. This allows you to configure it to an existing work items query and it can group by some attribute (e.g. Severity) which will show the count when hovered. In addition you can drill-through to the underlying items by clicking one of the bars of the graph.
Comments
That won't work with the way we have our dashboards setup. We need to keep the widget displays the same. Here is a visual representation:
So you already are using that viewlet. Your example doesn't appear to sort in any fashion. If by count ( desc ) would expect Med, High, Low. If by Priority would expect High, Low, Medium.
I just change same viewlet to your format and the sort is from largest count to smallest. My RTC is 4.0.7 [ I cannot add screen shots with this browser on my RHEL 6.6 o/s ]
