Find time duration from timestamp

Question & Answer
, ,
1

Hey,

I have a field called timeStampUTC containing timestamp with seconds as the granularity.

I want to find the max() and min() timestampUTC to find the ‘total duration’ = max(timestampUTC) - max(timestampUTC). This value will be a KPI. Is there a way to do this in QuickSight?

Screen Shot 2022-09-15 at 1.59.32 PM
Screen Shot 2022-09-15 at 1.59.32 PM664×822 45 KB

2

Hi @RossDickinson97,
Thank you for the question. The following calculation should help.

dateDiff(min({timeStampUTC},[{vid]),max({timeStampUTC},[{vid}]),"SS")
1 Like
3

Hi @bergqdou, thanks for your answer!