# View another field value instead of aggregation field

**URL:** <https://discuss.elastic.co/t/view-another-field-value-instead-of-aggregation-field/136083>\
**Category:** Kibana\
**Created:** [June 15, 2018, 10:59am UTC](https://discuss.elastic.co/t/view-another-field-value-instead-of-aggregation-field/136083 "2018-06-15T10:59:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sourav\_Saha](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@Sourav\_Saha](https://discuss.elastic.co/u/Sourav_Saha)\
**Post date:** [June 15, 2018, 10:59am UTC](https://discuss.elastic.co/t/view-another-field-value-instead-of-aggregation-field/136083/1 "2018-06-15T10:59:49Z")

</div>

Hi,

I am using Kibana Version: 6.2.4 and I have a vertical bar chart where in Y axis set Max aggregation for integer field TotalTime which is returning time in second. But I have another string field with calculated time in Hours, min and second, now I want to show the value of string field instead of integer field in bar chart keeping the same setup.

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [June 15, 2018, 3:22pm UTC](https://discuss.elastic.co/t/view-another-field-value-instead-of-aggregation-field/136083/2 "2018-06-15T15:22:03Z")

</div>

You can do this without using the other string field.  
Just go to your TotalTime field in the index pattern management, click on Edit for the format and set it to `Duration`.  
This will make it easily readable.

 ![field_format](https://us1.discourse-cdn.com/elastic/original/3X/5/1/51345ef97a9da85e26b930ab30a29086ffc8302c.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:** [July 13, 2018, 3:22pm UTC](https://discuss.elastic.co/t/view-another-field-value-instead-of-aggregation-field/136083/3 "2018-07-13T15:22:06Z")

</div>

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