Find time duration from timestamp


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.

1 Like

Hi @bergqdou, thanks for your answer!