# Kibana visualizations - Apply operations on value returned by a metric

**URL:** <https://discuss.elastic.co/t/kibana-visualizations-apply-operations-on-value-returned-by-a-metric/286356>\
**Category:** Kibana\
**Created:** [October 11, 2021, 10:07am UTC](https://discuss.elastic.co/t/kibana-visualizations-apply-operations-on-value-returned-by-a-metric/286356 "2021-10-11T10:07:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aza-zil](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aza-zil/32/92217_2.png) [@aza-zil](https://discuss.elastic.co/u/aza-zil)\
**Post date:** [October 11, 2021, 10:07am UTC](https://discuss.elastic.co/t/kibana-visualizations-apply-operations-on-value-returned-by-a-metric/286356/1 "2021-10-11T10:07:45Z")

</div>

I have a visualization where I have a metric field that contains the sum of durations (in millisecond), I want to show it in (hh:mm:ss) form, is that possible?

---

<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 11, 2021, 1:48pm UTC](https://discuss.elastic.co/t/kibana-visualizations-apply-operations-on-value-returned-by-a-metric/286356/2 "2021-10-11T13:48:41Z")

</div>

I think you have two options for this use case:

- set the field format as `Duration` type and configure it. This will have an effect on all visualizations for this field.
- create a `runtime_field` which takes the original field and configure the `format` only for the runtime version as `Duration`, so you can use either the original or runtime versions depending on the use case.

In both cases configure as follow the panel (check also the short suffix version):

 ![Screenshot 2021-10-11 at 15.48.15](https://us1.discourse-cdn.com/elastic/original/3X/2/7/2714d690b545c4042b24d663653b3c30f09f5680.png)

---

<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 8, 2021, 1:48pm UTC](https://discuss.elastic.co/t/kibana-visualizations-apply-operations-on-value-returned-by-a-metric/286356/3 "2021-11-08T13:48:46Z")

</div>

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