In Dashboard I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts

(0) Share

Report

Posted on by SASIKUMAR S

Hello,

I have requirement to show the dashboard from single table contains data which is have date field. Based on date field i need to calculate age of the server. I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts..

this is the sample pie chart

please help to resolve this issue...

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

Community Member on at

Like (0)

Report

Hi SASIKUMAR,

You can create two fields, one field to calculate age based on date field, another field is used to record whether it is more than 5 years old, then use then to set chart and dashboard.

1.create a calculate field ‘Year’ to calculate server age based on date.

2.create a new two option field ‘over 5 years’.

3.create a business rule.

4.create a new chart.

But you notice that pie chart show count not percentage, so you can use ‘Advanced Chart Editor’ of XRM Toolbox to customize the chart according following link:

https://www.loganconsulting.com/blog/add-percentage-labels-to-your-charts-in-dynamics-365-crm/

5.Add the pie chart to the dashboard.

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
Verified answer

Community Member on at

Like (0)

Report

Hi SASIKUMAR,

All settings above need open each record and save, then two fields will update, it’s very hard if you have large records.

So you can create an instant flow to bulk update existing records automatically., which don’t need calculated field and business rule, you just need create a simple field to store age and a two option field ‘over 5 years’.

Go Power Automate(https://us.flow.microsoft.com/en-us/ )

The following steps you need accord mentioned above(step4 & step5).

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
Verified answer

Community Member on at

Like (0)

Report

Hi Partner,

Has the problem been solved? Any updates?

Please click Yes under "Did this answer your question?" to close this thread.

Thanks.

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
SASIKUMAR S 30 on at

Like (0)

Report

Hello Leah,

Thanks for your suggestion. It is working fine ...

Was this reply helpful? Yes No