# Inner\_hits with Kibana visualizations

**URL:** <https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356>\
**Category:** Kibana\
**Created:** [November 20, 2017, 10:02am UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356 "2017-11-20T10:02:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mPanasiewicz](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@mPanasiewicz](https://discuss.elastic.co/u/mPanasiewicz)\
**Post date:** [November 20, 2017, 10:02am UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/1 "2017-11-20T10:02:45Z")

</div>

Is there any possibility to use inner\_hits in Kibana visualizations?? Is there any other solution to make join to use data from two documents in one axis?  
Example:

```
{
"payment": "1000",
"user_id": "10"
}

{
"id": "10"
"name": "John Smith"
}

```

I'd like to make dashboard users name with their payments.  
Thank you for help

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [November 20, 2017, 6:00pm UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/2 "2017-11-20T18:00:57Z")

</div>

I have pinged about this q to our team.  
cc  
/@ppisljar

---

<div class="post-metadata">

**Author:** ![mPanasiewicz](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@mPanasiewicz](https://discuss.elastic.co/u/mPanasiewicz)\
**Post date:** [November 21, 2017, 12:38pm UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/3 "2017-11-21T12:38:25Z")

</div>

My goal is to fetch child document with his parent(or fetch field from parent to the child document).

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [November 21, 2017, 4:36pm UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/4 "2017-11-21T16:36:24Z")

</div>

elastic search does not support joins, you would need to reindex your data with the name of user in the first document.

---

<div class="post-metadata">

**Author:** ![mPanasiewicz](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@mPanasiewicz](https://discuss.elastic.co/u/mPanasiewicz)\
**Post date:** [November 22, 2017, 8:30am UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/5 "2017-11-22T08:30:42Z")

</div>

@ppisljar you mean, I need to send first data with this user name? You mean that I have to do the join on application side, not on elasticsearch?

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [November 22, 2017, 9:50am UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/6 "2017-11-22T09:50:22Z")

</div>

i mean you should denormalize your data, (at index time, or reindex current data) so your documents look like this:

```auto
{
"payment": "1000",
"user_id": "10",
"user_name": "John Smith"
}

```

---

<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:** [December 20, 2017, 9:50am UTC](https://discuss.elastic.co/t/inner-hits-with-kibana-visualizations/108356/7 "2017-12-20T09:50:48Z")

</div>

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