# Get min value with timestamp

**URL:** <https://discuss.elastic.co/t/get-min-value-with-timestamp/170700>\
**Category:** Kibana\
**Tags:** elastic-stack-graph\
**Created:** [March 4, 2019, 10:01am UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700 "2019-03-04T10:01:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![itsroot](https://avatars.discourse-cdn.com/v4/letter/i/e9bcb4/32.png) [@itsroot](https://discuss.elastic.co/u/itsroot)\
**Post date:** [March 4, 2019, 10:01am UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700/1 "2019-03-04T10:01:53Z")

</div>

Hello,

I'm quite new to kibana and elasticsearch and I'm currently at creating a dashboard. I have a series of numbers and I want to know the min value of a given period of time. But I need to know at which time the value was on it's min (through a metric). How can I display these informations in my dashboard?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [March 5, 2019, 6:15pm UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700/2 "2019-03-05T18:15:52Z")

</div>

> But I need to know at which time the value was on it's min (through a metric)

This is not possible. Kibana visualizations display [aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations.html) results from Elasticsearch. An aggregation groups documents into buckets and calculates metrics for each bucket. There is no way to pull out one document property and associate that to the computed metric value.

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [March 5, 2019, 6:48pm UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700/3 "2019-03-05T18:48:24Z")

</div>

After further research, it is possible with [top hits aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-top-hits-aggregation.html)

 ![27%20AM](https://us1.discourse-cdn.com/elastic/original/3X/e/f/efcf19f69b8b7c0e909dcc986b9fcd0411e45ba6.png)

---

<div class="post-metadata">

**Author:** ![itsroot](https://avatars.discourse-cdn.com/v4/letter/i/e9bcb4/32.png) [@itsroot](https://discuss.elastic.co/u/itsroot)\
**Post date:** [March 8, 2019, 12:28pm UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700/4 "2019-03-08T12:28:20Z")

</div>

Thanks that worked out very well

---

<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:** [April 5, 2019, 12:28pm UTC](https://discuss.elastic.co/t/get-min-value-with-timestamp/170700/5 "2019-04-05T12:28:20Z")

</div>

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