Forum Discussion
Include zero/blanks in column chart (frequency table)
I actually got I to work in my dummy-file and I then comparied the settings between those two. Apparently, the right solution is to have the following settings...
Axis: number_of_emails, with "Show items with no data"
Value: number_of_emails, with "Count"
Default Summarization: on "Don't summarize" (number_of_emails)
Data settings: Relplaced nulls with zeroes
What I missed was that when I change "default summarization", for some reson, count switched over to sum. And the sum of a lot of zeroes is zero, so thats why no data was showing.
Thank you a lot for your help Tahreem24
I actually got I to work in my dummy-file and I then comparied the settings between those two. Apparently, the right solution is to have the following settings...
Axis: number_of_emails, with "Show items with no data"
Value: number_of_emails, with "Count"
Default Summarization: on "Don't summarize" (number_of_emails)
Data settings: Relplaced nulls with zeroes
What I missed was that when I change "default summarization", for some reson, count switched over to sum. And the sum of a lot of zeroes is zero, so thats why no data was showing.
Thank you a lot for your help Tahreem24
- Good to know that your issue is solved. If you shared the details of your issue so probably I could have answered your query.
Then, later when my suggestion didn't work for you (show item with no data) that's why I asked for dummy file.
Good luck!