2 Replies Latest reply on Aug 29, 2016 2:57 AM by Łukasz Majewski

    How to filter on distinct count that's based on several conditions (date range and others)

    Chen Lu

      I'd like to filter the clients based on the following conditions

      The client has 3+ distinct ERC# within the last 12 months or 6+ distinct ERC# since 1/1/2014.

      To break it down, there're multiple calculations that need to be included in the filter

      1. How to count distinct ERC# within a date range

      2. How to combine the two conditions together

      3. How to put them into a filter

       

      Sample data attached, please help!