Microsoft Dynamics 365 | Integration, Dataverse...

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

(0) Share

Report

Posted on by Jose Gregorio Diaz

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

All responses (3)

Answers (0)

Nya 29,056 on at

Like (0)

Report

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

Hi, Jose

The data of the chart is based on the view.

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.

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
Jose Gregorio Diaz 20 on at

Like (0)

Report

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.

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

Thank you for your help,

Jose G Diaz
Suggested answer

Nya 29,056 on at

Like (0)

Report

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?

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.

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