2 Replies Latest reply: Mar 24, 2017 12:36 AM by Silambarasan Manickam RSS

    i want expression to change based on filter selection

    Maria Harmening

      I'd like my default view to always calculate on this particular expression.

      Count(distinct {$ <BINFlagToday={1}>} BIN)

       

      however, I have quarter and FY filter panes.  if the user selects a value within the quarter filter pane, the expression needs to change to

      Count(distinct {$

      <BINFlagQuarter={1}>

      }
      BIN)

      and for FY

      Count(distinct {$

      <BINFlagFY={1}>

      }

      and if all selections are clear, I'd like it to go back to the default expression.

      how can I do this without having to make a duplicate page?