CRM 2011 Dashboard: Sorting a Chart On the Aggregate Value
The other day I created a basic chart in CRM 2011 which showed the total portfolio value for each portfolio manager. The result was here (redacted):
As you can see, the values were all over the place, so naturally I wanted to sort it from highest to lowest. Fortunately it was a quick matter of updating the chart XML with one line in the fetchcollection section after attributealias:
The end result was here (again redacted):
This was much better and easy to do. Yet another example of how to refine the out of the box charts within CRM 2011 to visualize data. If you’re interested in more examples, I’ve found this link from Microsoft to be quite helpful: http://msdn.microsoft.com/en-us/library/ee704599.aspx.