# I have servers data im visulaizing them in kibana. I used Top hit as the aggregation metric for last updated time. In the buckets i have other fields to look at the data like a table. But im getting duplicates how do i get rid of this

**URL:** https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094
**Category:** Kibana
**Created:** [March 12, 2021, 1:41pm UTC](https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094 "2021-03-12T13:41:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![sagar\_rao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sagar_rao/32/84702_2.png) [@sagar\_rao](https://discuss.elastic.co/u/sagar_rao)
#### Post date: [March 12, 2021, 1:41pm UTC](https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094/1 "2021-03-12T13:41:17Z")

</div>

![Screenshot (27)](https://us1.discourse-cdn.com/elastic/original/3X/5/1/5141f937d8014c2b7124be29afa2b53bdb3bf9bd.png) ![Screenshot (28)](https://us1.discourse-cdn.com/elastic/original/3X/b/7/b7e0ca0ce92d2e052a5e64b6325c7192cdd63b2f.png) ![Screenshot (29)](https://us1.discourse-cdn.com/elastic/original/3X/a/5/a518041cf82b7a3c849df3c2dc0ea065fc434414.png) ![Screenshot (30)](https://us1.discourse-cdn.com/elastic/original/3X/0/8/0861ec75d3da834a0fae52c1909a0378f326cca0.png)

---

<div class="post-metadata">

### Author: ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)
#### Post date: [March 12, 2021, 3:45pm UTC](https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094/2 "2021-03-12T15:45:24Z")

</div>

Which columns have duplicates that shouldn't?

It seems to me that you should use only one 'Split rows' bucket, on whichever field you want to be unique, then use a new top hit metric for every other field you would like to include as a column in the table.

---

<div class="post-metadata">

### Author: ![sagar\_rao](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sagar_rao/32/84702_2.png) [@sagar\_rao](https://discuss.elastic.co/u/sagar_rao)
#### Post date: [March 15, 2021, 6:47am UTC](https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094/3 "2021-03-15T06:47:08Z")

</div>

thank you Devon. Tha was helpful

---

<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 12, 2021, 6:47am UTC](https://discuss.elastic.co/t/i-have-servers-data-im-visulaizing-them-in-kibana-i-used-top-hit-as-the-aggregation-metric-for-last-updated-time-in-the-buckets-i-have-other-fields-to-look-at-the-data-like-a-table-but-im-getting-duplicates-how-do-i-get-rid-of-this/267094/4 "2021-04-12T06:47:36Z")

</div>

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