# Solving "join" issues

**URL:** <https://discuss.elastic.co/t/solving-join-issues/123584>\
**Category:** Kibana\
**Created:** [March 12, 2018, 3:44pm UTC](https://discuss.elastic.co/t/solving-join-issues/123584 "2018-03-12T15:44:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tomak](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@tomak](https://discuss.elastic.co/u/tomak)\
**Post date:** [March 12, 2018, 3:44pm UTC](https://discuss.elastic.co/t/solving-join-issues/123584/1 "2018-03-12T15:44:09Z")

</div>

In one index I have different retailers.

In another, I have different products with a list of who is selling these products.

For ease of manipulation latter on, and to "join" these two indexes, for the products, I have an array with the id's of the corresponding sellers.

I want to show a bar chart where I can see how many products are sold by which retailer.

Is this the best way of joining the two indexes:

I have a a bar char with count as Y metric and terms aggregation on seller.keyword  
This then gives me different numbers (the id's of the different sellers and how many products they're selling). Then, so that the user can knows who is who, I add a "discover" panel showing the id and the name of the seller.

Is this the best way of proceeding?

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [March 12, 2018, 5:11pm UTC](https://discuss.elastic.co/t/solving-join-issues/123584/2 "2018-03-12T17:11:53Z")

</div>

@tomak Kibana/Elasticsearch have very limited support for "joining" between different indices. Using a Dashboard and the filters the way that you are seems reasonable though.

---

<div class="post-metadata">

**Author:** ![tomak](https://avatars.discourse-cdn.com/v4/letter/t/d9b06d/32.png) [@tomak](https://discuss.elastic.co/u/tomak)\
**Post date:** [March 26, 2018, 7:57am UTC](https://discuss.elastic.co/t/solving-join-issues/123584/3 "2018-03-26T07:57:50Z")

</div>

And would you have any other suggestions as to how to solve 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:** [April 23, 2018, 7:58am UTC](https://discuss.elastic.co/t/solving-join-issues/123584/4 "2018-04-23T07:58:09Z")

</div>

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