Answered by:
CRM 2011 - Customizing Chart XML

Question
-
I have the following chart that is being grouped by week, so it's showing "Week 1 of 52," etc. I really want it to give the first date of the week, so "Week of 1/31/2013," etc. Does anyone know a solution for this?
<visualization>
<visualizationid>{BE6B34A8-4296-E211-9781-005056850042}</visualizationid>
<name>Total New Displays Required (NUM) by Scheduled Tech Visit</name>
<primaryentitytypecode>serviceappointment</primaryentitytypecode>
<datadescription>
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="serviceappointment">
<attribute groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" name="csm_scheduledtechvisit" dategrouping="week" />
<attribute alias="_CRMAutoGen_aggregate_column_Num_0" name="csm_totalnewdisplaysrequirednum" aggregate="sum" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="_CRMAutoGen_groupby_column_Num_0">
<measurecollection>
<measure alias="_CRMAutoGen_aggregate_column_Num_0" />
</measurecollection>
</category>
</categorycollection>
</datadefinition>
</datadescription>
<presentationdescription>
<Chart Palette="None" PaletteCustomColors="55,118,193; 197,56,52; 149,189,66; 117,82,160; 49,171,204; 255,136,35; 97,142,206; 209,98,96; 168,203,104; 142,116,178; 93,186,215; 255,155,83">
<Series>
<Series ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40"></Series>
</Series>
<ChartAreas>
<ChartArea BorderColor="White" BorderDashStyle="Solid">
<AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
<MajorGrid LineColor="239, 242, 246" />
<MajorTickMark LineColor="165, 172, 181" />
<LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
</AxisY>
<AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount">
<MajorTickMark LineColor="165, 172, 181" />
<MajorGrid LineColor="Transparent" />
<LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" />
</AxisX>
</ChartArea>
</ChartAreas>
<Titles>
<Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="59, 59, 59"></Title>
</Titles>
</Chart>
</presentationdescription>
<isdefault>false</isdefault>
</visualization>Tuesday, March 26, 2013 9:34 PM
Answers
-
It is not possible to achieve this on OOTB chart control from CRM 2011. But you can achieve this in SSRS report and embed that to Dashboard. As the grouping option is not standard, go with SQL queries to filtered views and then use SQL group by clause to achieve what you are after.
Hope this helps.
-----------------------------------------------------------------------
Minal Dahiya
If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
- Proposed as answer by VidhiyaM Wednesday, March 27, 2013 4:14 AM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, April 16, 2013 3:57 AM
Tuesday, March 26, 2013 11:10 PM -
These two links could help you in customization of the charts:
The second is about the SSRS type charts:
http://social.technet.microsoft.com/wiki/contents/articles/9677.microsoft-dynamics-crm-2011-ssrs-multi-series-chart-and-display-in-dashboard.aspx
If the answer helped you, remember to mark it as answer.
- Marked as answer by Payman BiukaghazadehEditor Tuesday, April 16, 2013 3:57 AM
Friday, March 29, 2013 6:16 AMModerator
All replies
-
It is not possible to achieve this on OOTB chart control from CRM 2011. But you can achieve this in SSRS report and embed that to Dashboard. As the grouping option is not standard, go with SQL queries to filtered views and then use SQL group by clause to achieve what you are after.
Hope this helps.
-----------------------------------------------------------------------
Minal Dahiya
If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
- Proposed as answer by VidhiyaM Wednesday, March 27, 2013 4:14 AM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, April 16, 2013 3:57 AM
Tuesday, March 26, 2013 11:10 PM -
These two links could help you in customization of the charts:
The second is about the SSRS type charts:
http://social.technet.microsoft.com/wiki/contents/articles/9677.microsoft-dynamics-crm-2011-ssrs-multi-series-chart-and-display-in-dashboard.aspx
If the answer helped you, remember to mark it as answer.
- Marked as answer by Payman BiukaghazadehEditor Tuesday, April 16, 2013 3:57 AM
Friday, March 29, 2013 6:16 AMModerator