Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Make empty data points show up as zero

Hello! I need to analyze data from a survey where people selected "Agree", "Somewhat Agree", "Somewhat Disagree" and "Disagree" to different questions. Upon building bar charts from this data (using...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    I'd like to suggest you confirm if these empty data did not really exist in your tables first. For this scenario, these empty data are expanded by the current category combo and you can't direct replace these values. 

    You need to extract category value as a new table and use this on your visual, then write measure formula to lookup value based on raw table category and new table value, replace the not matched parts with zero records.

    Replacing null values in matrix visual 

    Regards,

    Xiaoxin Sheng