Forum Discussion

manideep547's avatar
manideep547
Helper III
6 years ago

Customer next step

Hi all, My data look like below   CustomerId         DATE                        START                                                           END                    JOURNEY_STATE    1111       ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example and better data

Appreciate your Kudos.

 

  • manideep547's avatar
    manideep547
    Helper III
    6 years ago

    amitchandak  Here 2222 customer  from Arrival  (2020-01-02 15:49:09.000  session end previous record ) directly converted to  in Navigation1(2020-01-02 15:49:10.000 ,session start next record)
    count number of customers converted from arrival to Navigation1 =1

    Thanks for your reply 

     

    • manideep547's avatar
      manideep547
      Helper III
      6 years ago

      @amitchandak  My data
      CustomerId   DATE                        START                                             END                   JOURNEY_STATE
       1111             2020-01-02      2020-01-02 22:16:23.000    2020-01-02 22:19:02.000     Arrival
       1111             2020-01-02      2020-01-02 22:19:03.000      2020-01-02 22:23:17.000      Enquiry
        2222            2020-01-02     2020-01-02 15:48:21.000       2020-01-02 15:49:09.000      Arrival
        2222            2020-01-02      2020-01-02 15:49:10.000       2020-01-02 15:52:28.000     Navigation1

       

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        manideep547 

        I create a new column like :

         

        Is nav = if(ISBLANK( MiNX(FILTER(journey,journey[START]>EARLIER(journey[end]) && journey[CustomerId]=EARLIER(journey[CustomerId]) && journey[JOURNEY_STATE] = "Navigation1"),journey[START])),"No","Yes")

         

         

        You can modify as per need

        File is attached below signature . if you need more help make me @

        Appreciate your Kudos.