Share

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):

 

image

 

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:

 

image

The end result was here (again redacted):

image

 

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.