I have an index that has a numeric field representing seconds. That said, the stats I am presenting really needs to be in human readable so I have selected the format in the index pattern to be Duration. So, 180 seconds reads as 3 minutes. Perfect.
However, I am using another visualization to display the average time for a date range but when I do that the displayed average is shown in seconds rather than minutes. So for example the the average duration for the that day would be displayed as 180 (seconds) not 3 minutes.
Is there any way to have the average shown formatted for duration rather than the native seconds.