🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

How can I create a table/chart with a range of number, not just the one in the data.

Answered
Mark Waller 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.

5 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Public
Mark Waller December 7, 2020

Hello,
Yes, that worked – I added null events on each day and it fixed the problem.
Thanks.

Public
Mark Waller 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?

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 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

Please login or Register to Submit Answer