# Documents + visualizations from multiple data sets in my index (relational DB type feature)

**URL:** <https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986>\
**Category:** Kibana\
**Created:** [February 22, 2018, 6:09am UTC](https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986 "2018-02-22T06:09:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\
**Post date:** [February 22, 2018, 6:09am UTC](https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986/1 "2018-02-22T06:09:28Z")

</div>

Hi,  
I am trying to build a data table visualization using 2 data sets (both in the same index) that have one field in common. Example below.  
I am trying to display from the first data set, and summarize from the 2nd data set using that common field. Right now it shows zero, meaning it won't let me traverse past the first data set.

Example:

```auto
Set1: text_field1,text_field2,number_field3,number_field4,number_field5
set2: number_field6,number_field7,text_field8

```

I want to show:  
`Significant terms (text_field1) and significant terms (text_field2) and sum(number_field6) where text_field8=text_field2`

In a relational database this will look like this:

```auto
SELECT text_field1,text_field2, sum(number_field6)
FROM set1, set2
WHERE set2.text_field8 = set1.text_field2
GROUP BY text_field1,text_field2

```

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [February 22, 2018, 5:46pm UTC](https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986/2 "2018-02-22T17:46:09Z")

</div>

Sorry Dor. Elasticsearch doesn't have any kind of join functionality like that, and so Kibana doesn't have any way to support that.

The closest thing I can think of is to have some 2 visualizations in a dashboard and when you click on one of those test\_fields in one visualization it adds a filter so that both visualizations are filtered down to only one value of that text\_field.

---

<div class="post-metadata">

**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\
**Post date:** [February 22, 2018, 7:10pm UTC](https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986/3 "2018-02-22T19:10:57Z")

</div>

Thank you I ended up doing that.

---

<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:** [March 22, 2018, 7:10pm UTC](https://discuss.elastic.co/t/documents-visualizations-from-multiple-data-sets-in-my-index-relational-db-type-feature/120986/4 "2018-03-22T19:10:59Z")

</div>

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