Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Include zero/blanks in column chart (frequency table)

I have a table with number of emails sent per case   Data sample Case id Number of sent emails 11111 3 22222 null 33333 2 44444 1 55555 1   Result: Problem As yo...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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 

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Anonymous ,

 

RIght click on your axis in Field option under Visualization pane --> Select "Show item with no data". (Attched screen shot)

Don't forget to hit Thumbs up and accept this as a solution if you find it helpful! 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It has a green check mark but the 0-bar is till empty.