How to create a Pie chart to show Actual End Date(contain data) Vs Actual End Date(does not contain data) for an entity in dynamics crm

(0) Share

Report

Posted on by Pradip Raj

327

Hi,

I need to create a Pie chart where I needs to show count of Actual End Date(contain data) Vs Actual End Date(does not contain data). Is it possible ?

If yes, then how can we do this.?

Thanks

Pradip

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Anh Luu 215 on at

Like (0)

Report
In SQL query, add a new column like this

SELECT CASE WHEN ActualEndDate IS NULL THEN 1 ELSE 0 END AS EmptyDate FROM YourTable

Then in your chart, you can group by this EmptyDate column, and make the count on this column.

Was this reply helpful? Yes No
Pradip Raj 327 on at

Like (0)

Report

I am using Dynamics CRM 2016 Online. Here we can't query like SQL.

I need to create a Pie chart for dashboard for Campaign entity where need to show count for actual end date(contain data) vs actual end date(does not contain data).

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I use something similar to quantify opportunities which do not have an estimated close date. Create a chart and in the first Legend Entries select Actual End Date/Count: All. In the Horizontal Axis Labels select Actual End Date/Month. The resultant graph shows a pie with sections by month and one called (blank).

You could then edit the XML of the chart to change the labels and colors in the graph. My suggestion would be to set all the items that have an end date to use the same color, and make the font the same color as the pie pieces. Then the undated items will stand out with their own color and the font of the number will also provide the count.

Best of luck to you!

Was this reply helpful? Yes No
Pradip Raj 327 on at

Like (0)

Report

Hi Tricia,

In chart, "count" does not give us the total contain data count but it gives count of the records for an entity.

I have already created chart and in the first Legend Entries select Actual End Date/Count: All. In the Horizontal Axis Labels select Actual End Date/Month but not able to customize further as per requirements. I also need to show on horizontal axis the custom label like "Completed Compaigns" and "Outstanding Compaigns".

If you have any idea on how to customize it then please let me know.

Thanks

Was this reply helpful? Yes No
PS10 8 on at

Like (0)

Report

Hi Pradip

Did you get any solution for your question, i have some similar requirements, please do share what you did to achieve the above.

Thanks

PS

Was this reply helpful? Yes No