How to display KPI value of Seconds as HH:MM:SS AND allow aggregation

Question & Answer
, , , ,
1

Hi,
I am building a dashboard in QuickSight from Connect data.

I need to display the average wait time (Api Metric: OLDEST_CONTACT_AGE) for a filtered set of queues.

It works fine to display in seconds, but how can I display as HH:MM:SS in a way that allows aggregation?

I understand I can create a calculated field, Lets call it ValueAsHHMMSS to display the value as a formatted string Like this example but (as far as I can tell) I can’t aggregate it.

For example, I can’t display the Average of ValueAsHHMMSS

Thanks!
– Jeff

2

Hi @JeffGilbert

If the OLDEST_CONTACT_AGE is in seconds (integer) you can try aggregating it before formatting it.

1 Like
3

Thanks Mukilan,
Can you tell me how to format after aggregation?
I don’t see any format options that will allow me to format using a formula that would turn an int into hh:mm:ss
Cheers,
Jeff

4

Hello @JeffGilbert !

Are you still having trouble with this, and if you have found a solution could you post it to help the community?

If I understand correctly you want to take a timestamp of seconds and transform it into HH:mm:ss. You could try formatDate and then use that in calculated fields depending on your use case.

What type of aggregations are you trying to do?