# How to aggregate data on the dashboard from two different Indexes

**URL:** https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847
**Category:** Kibana
**Created:** [January 28, 2020, 1:40pm UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847 "2020-01-28T13:40:06Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Gustavo\_Batista](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gustavo_batista/32/47827_2.png) [@Gustavo\_Batista](https://discuss.elastic.co/u/Gustavo_Batista)
#### Post date: [January 28, 2020, 1:40pm UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847/1 "2020-01-28T13:40:06Z")

</div>

I need a very specific (maybe not that much) form of data aggregation from to different indexes to show on a dashboard panel.

I am making a sideways bar graph, and have two indexes that I need to use for it.

There is the User index and the Documents index. The user index has an array of favorite documents with the users favorite document's IDs, and the document's Index has the full information on the document.

What i need to do is a graph that shows the most favorited documents, and its reasonably easy to do so using only the id numbers, but that is it, the graph shows only ID numbers, not the actual document titles.

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

How do I cross the information on those two indexes? All i wanted was to show the titles of the documents on this panel, but I don't want to have to rely on coding some piece of software to aggregate those two informations on a new index.

---

<div class="post-metadata">

### Author: ![ponef](https://avatars.discourse-cdn.com/v4/letter/p/858c86/32.png) [@ponef](https://discuss.elastic.co/u/ponef)
#### Post date: [January 30, 2020, 12:32pm UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847/2 "2020-01-30T12:32:45Z")

</div>

Hi buddy, did you finally get a way out to this till date?

Regards,  
Noel Smith

---

<div class="post-metadata">

### Author: ![ponef](https://avatars.discourse-cdn.com/v4/letter/p/858c86/32.png) [@ponef](https://discuss.elastic.co/u/ponef)
#### Post date: [February 3, 2020, 7:21am UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847/3 "2020-02-03T07:21:43Z")

</div>

Hi buddy[,](https://vidmate.onl/) any update over this yet?

> [@ponef](#):
>
> Hi buddy[,](https://plex.software/) did you finally get a way out to this till date?
> 
> Regards,  
> Noel Smith

---

<div class="post-metadata">

### Author: ![Gustavo\_Batista](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gustavo_batista/32/47827_2.png) [@Gustavo\_Batista](https://discuss.elastic.co/u/Gustavo_Batista)
#### Post date: [February 3, 2020, 2:40pm UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847/4 "2020-02-03T14:40:17Z")

</div>

Not really, unfortunately it does not seem to be possible to do what I described above. therefore, just had to code an application that organizes the data the way i needed in another index before trying to create the panel.

---

<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 2, 2020, 2:40pm UTC](https://discuss.elastic.co/t/how-to-aggregate-data-on-the-dashboard-from-two-different-indexes/216847/5 "2020-03-02T14:40:24Z")

</div>

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