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.
1 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?
Please sign in to leave a comment.