Find time duration from timestamp

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?

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

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

Hi @bergqdou, thanks for your answer!