Is there a way i can use runningvalue()expression in a CRM Dashboard Chart?, like in SSRS reports ,Or add to to the existing aggregate methods ,Avg,Count:All,Count:Non-empty, Max ,Min ,Sum
Thanks
Asked
Active
Viewed 40 times
0
-
There is no way to do it. – Andrew Butenko Jun 15 '15 at 14:41
-
is this what you're talking about? https://crmchartguy.wordpress.com/2015/03/23/add-key-figures-to-dashboards-in-ms-dynamics-crm/ – Shane_Yo Jun 15 '15 at 14:43
-
@Andrii,Thanks, What!!! :( . – AndroidAL Jun 15 '15 at 14:44
-
@Shane_Yo, What I'm trying to display is the Cumulative Sales per month in a chart on Dashboard. – AndroidAL Jun 15 '15 at 14:47
-
You can add your suggestion on Connect portal. That could help to bring this feature to the next release - [https://connect.microsoft.com/dynamicssuggestions](https://connect.microsoft.com/dynamicssuggestions) – Andrew Butenko Jun 15 '15 at 14:47
-
You should be able to show stuff like sales per month - no worries. – Shane_Yo Jun 15 '15 at 14:50
-
Thanks @Andrii Butenko , i will add that suggestion, is there another way i could get the cumulative sales ? – AndroidAL Jun 15 '15 at 14:51
-
@Shane_Yo, Yep i can show sales per month , can i add equations to the charts? – AndroidAL Jun 15 '15 at 14:53
-
Your equations are limited to Data you query within your fetch, or the legend aggregates. – Shane_Yo Jun 15 '15 at 14:55
-
@Shane_Yo, So its only those in the image above i can use? – AndroidAL Jun 15 '15 at 14:57
-
You could be more creative with your fetchxml if you export your chart and work with it outside of the crm interface. – Shane_Yo Jun 15 '15 at 15:00
-
@Shane_Yo, okay, I have exported it to xml, but not sure where to start as very new to fetch xml. – AndroidAL Jun 15 '15 at 15:12
-
See if the link I posted above will help, it does take some time to get used to working with fetchxml - there are tools on the net also – Shane_Yo Jun 15 '15 at 15:14