# How to de-duplicate results in Kibana Search

**URL:** https://discuss.elastic.co/t/how-to-de-duplicate-results-in-kibana-search/242193
**Category:** Kibana
**Tags:** kql-kibana-query-language
**Created:** [July 22, 2020, 12:44pm UTC](https://discuss.elastic.co/t/how-to-de-duplicate-results-in-kibana-search/242193 "2020-07-22T12:44:21Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sxddhxrthx](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sxddhxrthx/32/46276_2.png) [@sxddhxrthx](https://discuss.elastic.co/u/sxddhxrthx)
#### Post date: [July 22, 2020, 12:44pm UTC](https://discuss.elastic.co/t/how-to-de-duplicate-results-in-kibana-search/242193/1 "2020-07-22T12:44:22Z")

</div>

I am trying to build dashboards using Shakespeare play data.  
on searching `play_name:*` in kql search box I am getting play names all the time they are indexed. I want to display one play names only once

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

Any help how can I get only unique values of play names?

---

<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: [July 23, 2020, 3:31pm UTC](https://discuss.elastic.co/t/how-to-de-duplicate-results-in-kibana-search/242193/2 "2020-07-23T15:31:08Z")

</div>

[Discover](https://www.elastic.co/guide/en/kibana/current/discover.html) shows individual documents from Elasticsearch.

It sounds like you want to display a table showing aggregated results so that you have one row per unique play\_name value. You can do this by creating a data table in [visualize](https://www.elastic.co/guide/en/kibana/current/most-frequent.html)

---

<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: [August 20, 2020, 3:31pm UTC](https://discuss.elastic.co/t/how-to-de-duplicate-results-in-kibana-search/242193/3 "2020-08-20T15:31:10Z")

</div>

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