# Show latest values for every unique value
**URL:** https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747
**Category:** Kibana
**Created:** [July 19, 2018, 1:58pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747 "2018-07-19T13:58:02Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@d\_s](https://discuss.elastic.co/u/d_s)
#### Post date: [July 19, 2018, 1:58pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/1 "2018-07-19T13:58:02Z")
Hello! I have information for a set of machines and I am trying to display only the latest values for various fields for each unique serial number. So for ex if I have:
serial# 1, temp: 100, color: red, date: 7/1/2018
serial# 1, temp: 100, color: red, date: 7/2/2018
serial# 1, temp: 100, color: red, date: 7/3/2018
serial# 2, temp: 99, color: blue, date: 7/1/2018
serial# 2, temp: 99, color: blue, date: 7/2/2018
serial# 2, temp: 99, color: blue, date: 7/3/2018
then my table should only show:
serial# 1, temp: 100, color: red, date: 7/3/2018
serial# 2, temp: 99, color: blue, date: 7/3/2018
Since serial 1 and 2 are unique and the 3rd of July is the most recent date.
Is this possible?
---
### Author:  [@jbudz](https://discuss.elastic.co/u/jbudz)
#### Post date: [July 19, 2018, 8:38pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/2 "2018-07-19T20:38:32Z")
Hey, can do. Terms on serial number and then you're looking for the top hits metric with a size of 1 sorted on your date field for the other columns.
Top hits lets you grab n values in a bucket and take the min, max, concatenation, or sum of them. Sorting by date with a size of one will give us the most recent number.
---
### Author:  [@d\_s](https://discuss.elastic.co/u/d_s)
#### Post date: [July 19, 2018, 9:34pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/3 "2018-07-19T21:34:46Z")
Thank you very much for the reply!
This works but I was trying to make a table of the information. Do you happen to know if there is any way to do that (sorry I should have specified that in the original question).
---
### Author:  [@jbudz](https://discuss.elastic.co/u/jbudz)
#### Post date: [July 19, 2018, 9:54pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/4 "2018-07-19T21:54:08Z")
Oh sorry about that, yes on more recent versions of Kibana. Which version of Kibana are you running? The data table visualization would have it at
---
### Author:  [@d\_s](https://discuss.elastic.co/u/d_s)
#### Post date: [July 19, 2018, 10:01pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/5 "2018-07-19T22:01:43Z")
Thank you so much! That was exactly what I needed ^.^
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 16, 2018, 10:05pm UTC](https://discuss.elastic.co/t/show-latest-values-for-every-unique-value/140747/6 "2018-08-16T22:05:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.