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

    Null Values

    Thomas Williams



      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.







          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)