5 Replies Latest reply on Sep 6, 2018 12:36 PM by Jim Dehner

    Filter observation which passed conditions DURING SELECTED DATES

    Anna Nathasia

      Hi,

       

      I need help on the filter/calculation part..

      I am trying to filter my observations based on conditions during the selected period.

      I am able to create the conditions, but it seems that the filter works across all periods instead of only the selected period.

       

      Example:

       

      Filter stores that have a minimum of 1mil cash flow and 15 transactions for each month during the last 3 months.

       

      Currently, my filter condition looks like this:

      Screen Shot 2018-09-07 at 01.19.08.png

      These conditions affect all period of observation instead of only the one I selected/shown.

      How do I make it only affect my selected period?

       

      Really appreciate your help!