SamCam

Thank you all! Many of these will work but the solution with the ETL was the easiest. Thank you for the help!

in How do I identify the second lowest value? I.e. MIN('COLUMN') +1? Comment by SamCam December 2018

Of course! And makes complete sense.

in How do I calculate time difference between two values in the same column and also group them? Comment by SamCam November 2018

Valiant, Thank you for your detailed response! I do want to know what is the average session duration by day - by summing the difference between each user's last and first API call and dividing by total users - so your Beast Mode is helpful but I'm not sure I understand all of it and it's currently not populating when I…

in How do I calculate time difference between two values in the same column and also group them? Comment by SamCam November 2018

SamCam Member

Comments