7 Replies Latest reply on Jun 6, 2018 1:34 PM by Deepak Rai

    Exclude nulls from bar chart

    Lauren Brown

      I have two values that I am showing in a bar chart.  However, in each value I have a null and I get the indicator "2 nulls."  When I click on filter data, it removes the entire chart and leaves nothing in the view.


      Below is the example of my chart, it is made up of two calculations Pre and Post ST Sales but because I am filtering on a product category "Non B Code" and B Code" and both categories do not belong in the calculations, I get nulls.


      How do I remove them from this chart?