Comments
-
Kind of what I was looking for but not quite. I ended up bringing the data into redshift and wrote sql code to get what I was looking for. Thanks for your help!
-
Yes i know that is the calculation to find the difference in time, but I am looking to base those calculations off of the specific ID numbers. Since there are multiple changes to a specific ID the calculation will be different than just the Timediff function. For the first time change of the ID, the time difference should…
