3 Replies Latest reply on Oct 18, 2018 9:12 AM by susheela.hegde

    Padding With Zeros Not working In Line Chart

    susheela.hegde

      Hi All,

       

      This is a simple question regarding padding zeros if there is null value/No data.

       

      I have used the calculation ZN(lookup(sum(sales),0)) to add the zeros.  This calculation works fine for text mark type as you see in attached worksheet.  how ever, I am not able to get the value zero for my line graph.

       

      If you see Sub category copiers in the line chart sheet, it doesn't have data in Jan and Feb and starts from March and ends in september. But when I change the mark type to Text, it shows zero.

       

      What is it I am missing in Line chart ?