Dynamics CRM chart

(0) Share

Report

Posted on by Community Member

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 -

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No