CRM 2011 Dashboard: Sorting a Chart On the Aggregate Value

/ By / User - CRM User Posts
Visit Website View Our Posts

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.

Post by: James Diamond, Customer Effective

Related posts:

  1. Out of the Box or With Some Configuration, Microsoft Dynamics CRM 2011 is a Great Solution
  2. Removing Query Data Cached by the OrganizationServiceContext in Microsoft Dynamics CRM
  3. A Wizard to Help Troubleshoot Microsoft Dynamics CRM Outlook Client Issues
  4. Send Faxes from Dynamics CRM 2011: A How To Guide
  5. Three Prudent Questions to Ask About Data Before the CRM Implementation

1 thought on “CRM 2011 Dashboard: Sorting a Chart On the Aggregate Value”

  1. Nagaraju

    i want to sort the bars of chart based on the opportunity "rating" .

    i.e. all the opportunities that contain rating as 'worm' are should be one place in the chart, and 'cold' opportunities should be at position, and 'hot' also.

    when i add any new opportunity with rating "worm" that opportunity bar should be the side of all worm opportunities.

Comments are closed.

Show Buttons
Hide Buttons