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:
Thank you in advance,
Jose G Diaz
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148