Sign in

Microsoft.com

Microsoft

Remove From My Forums

Sorting chart by year on dashboard

Question
0

Sign in to vote

Hi,

We've run into an issue with charts and sorting. We have a chart on a dashboard that should show sum per year of a custom entity. The aggregation works but the sorting is messed up. The resulting chart shows year 2016-2030 and then year 2015. If I show the chart from the view the years appear in the correct order. The system is a CRM 2013 SP1UR1, does anyone know if SP1UR3 helps this issue?

Regards

Rickard Norström Developer CRM-Konsulterna
http://www.crmkonsulterna.se
Swedish Dynamics CRM Forum: http://www.crmforum.se
My Blog: http://rickardnorstrom.blogspot.se

Tuesday, October 13, 2015 8:42 AM

All replies

0

Sign in to vote

You can download your chart and update fetchXML for sorting purpose as shown in some examples below.

https://crmchartguy.wordpress.com/2012/08/23/order-or-sort-your-charts/

http://us.hitachi-solutions.com/2011/06/02/crm-2011-dashboard-sorting-a-chart-on-the-aggregate-value/

Hope this helps
MayankP
My Blog
Follow Me on Twitter

Tuesday, October 13, 2015 9:28 AM

Answerer
0

Sign in to vote

Hi,

The issue is that it is sorted, för years 2016-2030 and then 2015 shows up after 2030. This only happens on the dashboard, if I look at the chart from the view it sorts fine.

Regards
Rickard Norström Developer CRM-Konsulterna
http://www.crmkonsulterna.se
Swedish Dynamics CRM Forum: http://www.crmforum.se
My Blog: http://rickardnorstrom.blogspot.se

Tuesday, October 13, 2015 11:12 AM