4 Replies Latest reply: Jan 23, 2018 7:53 PM by THIAGO TEIXEIRA RSS

    using the if statement while ignoring filters

    Andy Cosgrove

      I'm using the expression below on a line chart that includes a month filter as the chart shows data on a monthly basis

      Avg(if(Year>=2016,value))

      Using the same expression I want to be able to ignore the month filter.

      I have previously used set analysis Avg({$<Month=>},value) to ignore the month filter but I'm not sure how to add the if statement

      Thanks for your assistance

       

      Regards,

      Andy