# Visualisation for multiple indexes, using same ids

**URL:** https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274
**Category:** Kibana
**Created:** [April 17, 2019, 10:35am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274 "2019-04-17T10:35:20Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)
#### Post date: [April 17, 2019, 10:35am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274/1 "2019-04-17T10:35:21Z")

</div>

Hi folks,

I have a requirement for a line chart which uses two indexes. For the first index, I want to get a top 5 based on a metric, and therefore show a line chart for id1, id2, id3, id4, id5 displaying the metric as the y-axis (x-axis would be time).

For the second index, I want to return further data for the same ids as above, again using time as the x-axis. It feels like this should be a Timelion solution, but I haven't seen a suitable example.

I may need to perform some subtraction too, at a later point - hence why I'm looking at Timelion.

Can anyone assist please?

---

<div class="post-metadata">

### Author: ![monfera](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/monfera/32/26467_2.png) [@monfera](https://discuss.elastic.co/u/monfera)
#### Post date: [April 17, 2019, 11:40am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274/2 "2019-04-17T11:40:27Z")

</div>

Simon, can you give your current queri(es) that come closest, using one of the three standard Kibana sample datasets (Flights, eCommerce or Logs) so we can look at the same thing, and your info on where they fall short?

---

<div class="post-metadata">

### Author: ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)
#### Post date: [April 18, 2019, 9:41am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274/3 "2019-04-18T09:41:27Z")

</div>

Hi Robert,

I've just looked at the sample datasets, and do not believe I can get a query that is close - as there doesn't appear to be a single field that is common amongst them. Let me see if I can explain.

**sales** (Index)  
order\_id  
product\_id  
order\_date

**products** (Index)  
product\_id  
product\_name  
product\_category

Let's say I want to get the top 5 products sold from the Sales index, and show them on a line chart for the preceding 7 days. In a separate pie chart, I'd like to show the breakdown by product\_category - only for those product\_ids returned by the first chart.

Is this possible?

---

<div class="post-metadata">

### Author: ![singhster](https://avatars.discourse-cdn.com/v4/letter/s/a9adbd/32.png) [@singhster](https://discuss.elastic.co/u/singhster)
#### Post date: [May 7, 2019, 8:24am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274/4 "2019-05-07T08:24:41Z")

</div>

Hi, does anyone know if this is possible in Kibana?

---

<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: [June 4, 2019, 8:24am UTC](https://discuss.elastic.co/t/visualisation-for-multiple-indexes-using-same-ids/177274/5 "2019-06-04T08:24:45Z")

</div>

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