Question
How do I change my query to display time-based results as HH:MM:SS?
Answer
You can change the time-based results of your queries in Explore by clicking on the chart configuration (
) menu. Click Display format and change the dropdown to Duration.
Changing the display format to Duration only works if your time-based metric is displayed in seconds. The duration display format is intended to convert metrics that are based on seconds to the HH:MM:SS format. It will not work for any other unit of time, such as minutes or hours.
For more information, see the article: Changing the format of results.
3 Comments
Hello,
This doesn't appear to be accurate for all time-base results.
I have a default metric, AVG First reply time - Business hours (min), that's displays 182 minutes as a result. Changing the display format to Duration as instructed makes the format 00:03:02 (DD:HH:MM) and not HH:MM:SS.
I've also tried this with AVG First reply time - Business hours (hrs). By default, that returns 3.0 hrs. Changing the display format to Duration changes this to ??:DD:HH, or 00:00:03.
Is there any way for me to standardize all of my time-based results so I don't have to specify these formatting differences in my dashboards?
We're new to explore and would also love to be able to do what Jackson's asking. When we're viewing chat wait times, 1.3 minutes is less helpful and hh:mm:ss breakdowns.
Hello!
I'm afraid only the attributes displayed in seconds by default can be converted to the format HH:MM:SS. At this time, there is no known workaround to edit the display format of other units of time (attributes in minutes or hours) to be shown in that format. Sorry about this limitation, Dan and Jackson.
Thanks!
Please sign in to leave a comment.