1 Reply Latest reply: Apr 30, 2018 12:00 PM by Fernanda Gomez RSS

    Null Values

    Thomas Williams

      Hi,

       

      Is there a way of including a date range within my measure to show current month values and exclude Null values?

        • Re: Line Chart 0 Values
          Fernanda Gomez

          You can do in the chart like this but this deleted all the months with value 0.

          ejemplo.PNG

           

           

           

           

           

          or in the script deleting all records with values equal to 0:

          LOAD * FROM TABLE

          WHERE VALUE>0;

           

          or in the script with a flag and use in kpi:

          LOAD *,

          if(VALUE>0, 1,0) as flag

          FROM TABLE;

           

          sum({<flag ={1}>}VALUE)