Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Chart/Graph is displaying null or not existing values in the database

(0) ShareShare
ReportReport
Posted on by 20

Dear,

I am building a chart in dynamics, but the chart is displaying not existing values in the database yet as null (2021 line for example) and plot it in the chart, I would like to know if there is a way to avoid the chart to do it and just leave only one dot with the value that has data for 2021, below the example:

2514.pastedimage1611759800856v2.png

Thank you in advance,

Jose G Diaz

  • Nya Profile Picture
    Nya 29,056 on at
    RE: Chart/Graph is displaying null or not existing values in the database

    Hi, Jose

    2605.png

    The data of the chart is based on the view.

    0878.png

    So I tried to add a filter condition that saleamount must contains data.

    As you can see in the following picture, the point of the data for each month is an image.

    63002.png

    The point of 2021.01 is named as ‘2021 for month 1 has value of $30,000.00’, while the points of the null values are named as ‘Order. Month, 0’. The 0 will be automatically filled in the name of it.

    So the only way to achieve the effect which you need is to set the images of these points as invisible, but it is not recommended for this method since the data can change dynamically in real time.

     

    Best Regards,

    Nya

  • RE: Chart/Graph is displaying null or not existing values in the database

    Hi Nya,

    Thank you for your answer, to answer your questions yes what you mention is what i would like to achieve.

    But I don't understand, based on your comments if this is going to be possible and if yes what changes need to be made. Below you have more information about the field and chart definition.

    pastedimage1611842273547v1.png

    pastedimage1611842510603v3.png

    pastedimage1611842586217v4.png

    pastedimage1611842711478v6.png

    Additionally, I had to create a filter in the view to filter values greater than zero and the same thing happens in the chart. Below a couple of screenshots

    pastedimage1611953929046v1.png

    pastedimage1611953929047v2.png
    pastedimage1611953929047v3.png
    pastedimage1611953929048v4.png

    Thank you for your help,

    Jose G Diaz

  • Suggested answer
    Nya Profile Picture
    Nya 29,056 on at
    RE: Chart/Graph is displaying null or not existing values in the database

    Hi, Jose

    Do you want to achieve the effect of showing only one point of data for January 2021 when there is no data for other months?

    7416.png

    I have tried to change the field type of the field ‘Year’ and ‘Month’, such as a custom option set, calculate from the date or extract year and month from date field with workflow.

    But unfortunately, the null value cannot be ignored in a chart by the existing screening criteria.

    87304.png

    Non-empty should have been a useful filter, but it is only for Count.

    For the month itself can be seen as an option set, if the corresponding value is available for the current month in other years, a null value will be automatically populated with years that do not have data for the current month.

     

    Please let me know if you have any further questions.

    Best Regards,

    Nya

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans