# Fields values under Metrics Aggregations were rounding to zero in Kibana Line Charts

**URL:** <https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607>\
**Category:** Kibana\
**Created:** [December 29, 2017, 6:29pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607 "2017-12-29T18:29:39Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![govinda.rao](https://avatars.discourse-cdn.com/v4/letter/g/f14d63/32.png) [@govinda.rao](https://discuss.elastic.co/u/govinda.rao)\
**Post date:** [December 29, 2017, 6:29pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/1 "2017-12-29T18:29:39Z")

</div>

HI, I need your help,  
In line chart, Unable to generate lines in Y axis using same fields (processing time & Total delay) values. And X axis should be the Time filed. Please help how to achieve this without using aggregation functions, when i use aggregation functions all the values were rounding to zero. But i want graph using same floating values.

**Below is the data:**

 ![Kibana](https://us1.discourse-cdn.com/elastic/original/3X/e/c/ece04b0c8d30ffd4e29025f5b3ac401e6a8bd369.JPG)

**Here is the metrics screen shot.**

 ![Metrics](https://us1.discourse-cdn.com/elastic/original/3X/6/b/6b14eef12e4ee6fd15ea9a8c3cd016edc65f19cf.JPG)

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [December 29, 2017, 8:37pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/2 "2017-12-29T20:37:37Z")

</div>

hi @govinda.rao

what's the result of the unique-count query? You can see the raw values when opening the spy-panels (little grey arrow bottom left).

Also, are you sure you want to see unique counts, and not some other aggregation value for these fields (processing time, totaldelay), like sum or average?

Thanks,

---

<div class="post-metadata">

**Author:** ![govinda.rao](https://avatars.discourse-cdn.com/v4/letter/g/f14d63/32.png) [@govinda.rao](https://discuss.elastic.co/u/govinda.rao)\
**Post date:** [January 2, 2018, 4:16pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/3 "2018-01-02T16:16:28Z")

</div>

Yes, I want raw values to be displayed in kibana without any aggregations. And also, I am able to see the correct values after checking for spy-panels.

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [January 3, 2018, 9:02pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/4 "2018-01-03T21:02:47Z")

</div>

You can use a field-formatter to format your values.

under your index-pattern, choose the field and select the format.

You could specify a format for your numbers specifically:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/9/a9befd8f8f184dd7232e50c620673ff2e3b9ed23.png)

You can also select `String`, and then show the raw value.

---

<div class="post-metadata">

**Author:** ![govinda.rao](https://avatars.discourse-cdn.com/v4/letter/g/f14d63/32.png) [@govinda.rao](https://discuss.elastic.co/u/govinda.rao)\
**Post date:** [January 15, 2018, 12:29pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/5 "2018-01-15T12:29:09Z")

</div>

Thanks Thomas. This help me on fixing the issue.

---

<div class="post-metadata">

**Author:** ![govinda.rao](https://avatars.discourse-cdn.com/v4/letter/g/f14d63/32.png) [@govinda.rao](https://discuss.elastic.co/u/govinda.rao)\
**Post date:** [January 16, 2018, 5:01pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/6 "2018-01-16T17:01:25Z")

</div>

Hi Thomas, I need another help here. How can get the difference between this start time and end time in kibana. Below time field is string type

11:40:34,899 INFO RecoverableZooKeeper:120  
11:40:34,899 INFO ZooKeeper:438  
11:40:34,905 INFO ClientCnxn:975  
11:40:34,909 INFO ClientCnxn:852  
11:40:34,918 INFO ClientCnxn:1235  
11:40:34,985 INFO ConnectionManager$HConnectionImplementation:1830  
11:40:34,987 INFO ZooKeeper:684  
11:40:34,987 INFO ClientCnxn:512

---

<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:** [February 13, 2018, 5:01pm UTC](https://discuss.elastic.co/t/fields-values-under-metrics-aggregations-were-rounding-to-zero-in-kibana-line-charts/113607/7 "2018-02-13T17:01:37Z")

</div>

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