# Elasticsearch-query-for-distinct-fields-in-documents-of-same-index

**URL:** <https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998>\
**Category:** Kibana\
**Created:** [August 6, 2019, 11:33am UTC](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998 "2019-08-06T11:33:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sahadevan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sahadevan/32/51734_2.png) [@sahadevan](https://discuss.elastic.co/u/sahadevan)\
**Post date:** [August 6, 2019, 11:33am UTC](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998/1 "2019-08-06T11:33:09Z")

</div>

Document 1:

```
{
  _id = 1,
  _index = "desktop_apps"
  chrome_app_name: "chrome",
  chrome_app_version: "1.2",
  user: "user1"
}

```

Document 2:

```
{
  _id = 2,
  _index = "desktop_apps"
  firefox_app_name: "firefox",
  firefox_app_version: "1.3",
  user: "user1"
}

```

each document in the index 'desktop\_apps' has distinct fields for the same user.

I want to create an visualization in kibana for the user like this,

[![enter image description here](https://i.stack.imgur.com/wgsbk.png)](https://i.stack.imgur.com/wgsbk.png)

How to achieve this particular behavior. I am trying to create a search query  
and build visualization based on the search. How do i build my search query for this case?

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 6, 2019, 3:03pm UTC](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998/2 "2019-08-06T15:03:06Z")

</div>

You probably need to transform this data before visualizing it. In Elasticsearch 7.3 there is a free (basic license) feature for [continuous data frame transforms](https://www.elastic.co/guide/en/elastic-stack-overview/7.3/ecommerce-dataframes.html) which lets you do this, or you can use a transform pipeline like Logstash to do this.

---

<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:** [September 3, 2019, 3:03pm UTC](https://discuss.elastic.co/t/elasticsearch-query-for-distinct-fields-in-documents-of-same-index/193998/3 "2019-09-03T15:03:17Z")

</div>

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