Skip to main content
Dynamics 365 general forum
Answered

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

editSubscribe (0) ShareShare
ReportReport
Posted on by 30

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...

Categories:
Attachments
  • SASIKUMAR S Profile Picture
    SASIKUMAR S 30 on at
    RE: In Dashboard I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts

    Hello Leah,

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

  • Verified answer
    Community Member Profile Picture
    Community Member UG Leader on at
    RE: In Dashboard I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts

    Hi Partner,

    Has the problem been solved? Any updates?

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

    pastedimage1605866709034v1.png

    Thanks. 

    Regards,

    Leah Ju

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

  • Verified answer
    Community Member Profile Picture
    Community Member UG Leader on at
    RE: In Dashboard I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts

    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/ )

    pastedimage1605255729656v1.png

    pastedimage1605256143620v2.png

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member UG Leader on at
    RE: In Dashboard I want to List of devices whose ageing is above 5 years and Below 5 years within one pie charts

    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.

    pastedimage1605168918272v1.png pastedimage1605168923648v2.png

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

    pastedimage1605168937627v3.png

    3.create a business rule.

    pastedimage1605168950386v4.png

    4.create a new chart.

    pastedimage1605168966437v5.png

    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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans