6 Replies Latest reply on Jul 2, 2018 7:15 AM by andre.kempe.1

    Get date of one dimension member with last day >10 visits

    andre.kempe.1

      Hi, I tried so many things already but don't get to the solution.

      Imagine I manage 10 affiliates that produce visits to my page every day. Out of a sudden one affiliate churns. Now I want to know the last date when the affiliate delivered >10 visits.

      The table below is a good example. Desired output for A1 would be 2/1/2018

       

      DateAffiliateVisits
      1/1/2018A1500
      1/1/2018A220
      2/1/2018A115
      2/1/2018A220
      3/1/2018A12
      3/1/2018A220