Answered

Dynamics CRM chart

(0) Share

Report

Posted on by Community Member Microsoft Employee

I created a view for case(incident) entity for cases resolved in last 72 Hrs. Used this view to create a column chart to show number of cases resolved in a day. So it will be for last three days. It is working fine. When there are no resolved cases a any of the last three days chart will not the label for that day in X axis. But business want to see the date label with count as 0. And also they want to exclude the Saturdays and Sundays from the days count.

i.e if i am viewing the chart in dash board on Monday (28-Dec) then it should show data for Thursday(24-Dec), Friday(25-Dec) and Monday(28-Dec). These three dates should be shown in X-axis as labels even there are no resolved cases for these dates. Some thing like this -

Categories:

Development / Customization / SDK

All responses (3)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics CRM chart

Hi upenmet,

The Resolve on date field can be filled when case has been resolved, if not, the field is null, so it can’t show in the char.

You can’t make one value that don’t exist show in the chart.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics CRM chart

Hi Leah Ju,

Thank you for providing the solution. My base chart is same as what you showed here with only 1 difference. I used resolvedon date in place of modifiedon. But it is not working.. I changed the xml by using xrmtoolbox chart editor as there is no import option in charts for me. we are using Dynamcis CRM 2020 release with wave2.

My modified code -

<fetchcollection>

<fetch mapping="logical" aggregate="true">

<entity name="incident">

<attribute name="resolvedon" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" dategrouping="day" />

<link-entity name="incident" from="incidentid" to="incidentid" link-type="outer">

<attribute name="title" aggregate="countcolumn" alias="_CRMAutoGen_aggregate_column_Num_0" />

<filter type="and">

<condition operator="eq" value="1" attribute="statecode" />

</filter>

</link-entity>

</entity>

</fetch>

</fetchcollection>

As my view filters data for last 72 Hrs, and today is 29th i expected it to show 0 count for 27th and 28th
Community Member Microsoft Employee on at

Like (0)

Report

RE: Dynamics CRM chart

Hi upenmet,

You can refer following link to make the record that value is 0 show in the chart.

1.you need create a basic chart, then export it.

2.modify the xml file that download.

We need replace the highlighted attribute in the fetchcollection of the XML file,

Original:

New:

3.Reimport the file after modifying it.

Now, it can show record that value is 0 in chart.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.