# Dashboard based on data from 2 indexes

**URL:** <https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419>\
**Category:** Kibana\
**Created:** [March 23, 2022, 8:07am UTC](https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419 "2022-03-23T08:07:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shinobu](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@shinobu](https://discuss.elastic.co/u/shinobu)\
**Post date:** [March 23, 2022, 8:07am UTC](https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419/1 "2022-03-23T08:07:17Z")

</div>

Hello,

I want to create a Dashboard with a table thats showing me every url that does not a specific value in another field.

So basically i have 2 indexes:

Alert index:

```auto
{
  "url": "sometemplateurl.com"
}

Lookup Index:
{
 "Lookedup-Url": "sometemplateurl.com",
 "Attributea": "test"
}

```

The resulting table should show all alert urls that do not have attributea with the value "test". I can't use directly the Lookuptable for that, because I need the difference of Alerts - Lookup.

Is there a way to achive this?  
Hope you can help me out.

Best Regards.

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [March 23, 2022, 3:21pm UTC](https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419/2 "2022-03-23T15:21:16Z")

</div>

Since Elasticsearch query joins [are limited](https://www.elastic.co/guide/en/elasticsearch/reference/current/joining-queries.html), I don't think you can achieve this directly in Kibana without a denormalization process. For this you could use the [enrich processor](https://www.elastic.co/guide/en/elasticsearch/reference/current/ingest-enriching-data.html) to transfer fields from your look-up index into your alert index.

---

<div class="post-metadata">

**Author:** ![shinobu](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@shinobu](https://discuss.elastic.co/u/shinobu)\
**Post date:** [April 1, 2022, 8:57am UTC](https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419/3 "2022-04-01T08:57:25Z")

</div>

Ok, thank you for your advice I will try it this way.

---

<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 29, 2022, 8:57am UTC](https://discuss.elastic.co/t/dashboard-based-on-data-from-2-indexes/300419/4 "2022-04-29T08:57:54Z")

</div>

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