Forum Discussion

manideep547's avatar
manideep547
Icon for Helper III rankHelper III
6 years ago

Customer next step

Hi all, My data look like below   CustomerId         DATE                        START                                                           END                    JOURNEY_STATE    1111       ...
Need Help
manideep547's avatar
manideep547
Icon for Helper III rankHelper III
6 years ago

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. 


 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

manideep547 , Can you share this data with the expected output? Let me check again

 

  • manideep547's avatar
    manideep547
    Icon for Helper III rankHelper III
    6 years ago

    amitchandak 
    values in co column are like below   
    1]Enquiry
    2]Departure
    3]Navigation2
    4]Navigation2
    5]Navigation2
    6]Navigation2
    7]Navigation2
    8]Navigation2
    9]Navigation2
    10]Navigation2
    11]Navigation2
    12]Departure
    13]Navigation2