5 Replies Latest reply: Dec 5, 2017 3:48 PM by Sunny Talwar RSS

    Ignore NULL values on chart

    Ryan Metcalf

      How do I exclude dimension values that have a NULL measure?  For example, in my bar chart I have employees that do not have data (so their measure value is NULL), but they are still showing up on my chart.  How do I remove them?

       

      When I remove the check from "Include zero values" from the Data Handling menu not only does it remove dimensions with a NULL measure it also removes dimensions with a value of zero.  I want to keep the zero values, but get rid of the NULL values.