12 Replies Latest reply on Sep 18, 2018 1:25 PM by Shinichiro Murakami

    how to identify a service in the data based on date?

    Tony Fahd

      hi so I am trying to identify a service for my customers that fall prior to certain date and other service. see below

       

      I have millions of customers and I like to be able to identify all services that happened prior to the "Consult" service. so for customer A, I like to to be able to see that he had a "strategy" service prior to "Consult". I don't really care about the finance service he had since that service took place after the consult. same thing for my customer B. i like to do it on aggregate level, so be able to sum or count the type of services that took place prior to the "Consult" service and the number of days in between any service prior to Consult.

       

      Any help is appreciated