asked on November 28, 2020
I have some usage data which I am using to create a chart showing count by day of the week. The data has some gaps, i.e. on some days there is no usage, there are no rows with that day.
How can I create a chart with a range of values on the x-axis include the missing days? i.e. show a zero count on the day with no usage.
⋅ November 30, 2020
Hi Mark,
Thank you for posting your question.
As long as the input data set contains the days where there is no usage (e.g., a day member with 0 value), the chart should be displayed as expected.
In case your data does not contain the day members in question, we would recommend preprocessing the data set to add the missing days with 0 values to ensure all the days are displayed in the chart.
Please let us know if this helps.
Best regards,
Mykhailo
⋅ December 7, 2020
Hi Mark,
How are you?
Just checking in to ask if you've had a chance to look through our previous response. Have you found it helpful, or is there still anything we can help you with?
Please let us know your thoughts.
Kind regards,
Mykhailo
⋅ December 7, 2020
Hello,
Yes, that worked - I added null events on each day and it fixed the problem.
Thanks.
⋅ December 17, 2020
Actually this solution doesn't entirely work. If I have a report that includes a filter, perhaps for license type, then the null rows get filtered out. It isn't practical to add a whole set of null rows for every possible field we might want to filter by.
Is there another way to do this?
⋅ December 18, 2020
Hi Mark,
Thank you for reaching out!
Do you think you could send us a sample illustrating your current issue? This would help us understand your requirements better and provide you with the most relevant solution.
Looking forward to your reply.
Regards,
Mykhailo
