# Kibana visualization output format

**URL:** <https://discuss.elastic.co/t/kibana-visualization-output-format/345856>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [October 26, 2023, 5:37pm UTC](https://discuss.elastic.co/t/kibana-visualization-output-format/345856 "2023-10-26T17:37:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Banchs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chris_banchs/32/126704_2.png) [@Chris\_Banchs](https://discuss.elastic.co/u/Chris_Banchs)\
**Post date:** [October 26, 2023, 5:37pm UTC](https://discuss.elastic.co/t/kibana-visualization-output-format/345856/1 "2023-10-26T17:37:54Z")

</div>

Hi everyone!

Im new to Kibana...  
I have a scripted field that calculates a total time of a task. The format is in seconds (EPOCH) and I would like to make a visualization (Metric type) that calculates the average time of all tasks.  
The problem I have is that I would like the average to be displayed in human readable... Maybe using a script to divide the average result in days, minutes, seconds etc...  
Im unable to find how to format the average's output in the visualization.

Any help on how to do this or better ways to do this are appreciated  
Im using Kibana 6.8

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [October 27, 2023, 9:49am UTC](https://discuss.elastic.co/t/kibana-visualization-output-format/345856/2 "2023-10-27T09:49:56Z")

</div>

Hi @Chris_Banchs

the mentioned stack version is a bit old and unsupported.  
In recent versions (\> 8.9 I think) there's the Lens editor with a bespoken Duration formatter exactly for that.  
On previous versions (7.x, 8.x) field formatters would provide some date formatting options to achieve something like that.

---

<div class="post-metadata">

**Author:** ![Chris\_Banchs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chris_banchs/32/126704_2.png) [@Chris\_Banchs](https://discuss.elastic.co/u/Chris_Banchs)\
**Post date:** [October 27, 2023, 3:09pm UTC](https://discuss.elastic.co/t/kibana-visualization-output-format/345856/3 "2023-10-27T15:09:21Z")

</div>

Hi Marco,  
I wasn't aware this version was so old. Ill look into it.  
Thank you so much for your reply!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 24, 2023, 3:10pm UTC](https://discuss.elastic.co/t/kibana-visualization-output-format/345856/4 "2023-11-24T15:10:05Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.