Forum Discussion
Customer next step
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
@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
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.amitchandak
I think we should not use the journey, [START]>EARLIER(journey[end]) see the above fig.
co column, define the next step of the customer.
In the above data, the customer started his journey at arrival 2:10:07 Pm and next he went to Enquiry 10:55:16 PM in that column co the value should be Enquiry I am not getting which constraint we have to add to get that values.manideep547 , Can you share this data with the expected output? Let me check again
