4 Replies Latest reply: Jan 23, 2018 7:53 PM by Thiago Justen 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


      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