Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate time difference

Hi Guys,

 

I have a data set where is information about email delivering and opening and I want to see how long does it take to user to open the email.

Problem is, that I do not have separate columns for deliver and open, so I cant just subtract one value from another  but something like this (where I have a column "status" where are more values like delivered, opened, etc and every row has its timestamp + date & time):

I can create a matrix where I can see for every email information when was delivered and when (if) was opened and I need a third column where will be the time how much it took the user to open an email (so open minus delivered)

 

 

 

 

 

 

 

 

 

 

 

Is it possible?

 

Thank you

Lukas

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi EVEAdmin,

       

      thank you for reply but I am not sure if I follows. On the link you provided is not the solution to my problem or am I missing something?

       

      I dont need to convert timestamp to standard date time (or I needed it and I used the solution from this thread you sent :) )

       

      I need a new measure where will be the difference (EG from my table the first row should be 9:49:10 etc)

       

      Thanks

      Lukas

      • EVEAdmin's avatar
        EVEAdmin
        Post Patron
        7 years ago

        If you convert the timestap to standard date time, then you calculate the difference between the 2 dates