# Filter Dashboard from different json

**URL:** https://discuss.elastic.co/t/filter-dashboard-from-different-json/92807
**Category:** Kibana
**Created:** [July 12, 2017, 12:58pm UTC](https://discuss.elastic.co/t/filter-dashboard-from-different-json/92807 "2017-07-12T12:58:42Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![xavi23](https://avatars.discourse-cdn.com/v4/letter/x/db5fbb/32.png) [@xavi23](https://discuss.elastic.co/u/xavi23)
#### Post date: [July 12, 2017, 12:58pm UTC](https://discuss.elastic.co/t/filter-dashboard-from-different-json/92807/1 "2017-07-12T12:58:42Z")

</div>

Hello,

I have a big problem when I filter one dashboard with differetns visualizations.

The data that I try to load in my index are so:

I have one patient that have some episodes, and any episode have diferent data that others episodes fromm the same patient.

The problem is that always I have some fields that neever change. This information is the basic patient information: Name, Birthdate, etc...

I have one JSON for each episode because Kibana don't support nested fields.

If i load the basic patient information in other json, when I filter with one field of episode, I don't see the patient information. If I load always the patient data in all json, I have duplicate data innecessary.

How I can resolve this situation?

thanks.

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [July 12, 2017, 11:54pm UTC](https://discuss.elastic.co/t/filter-dashboard-from-different-json/92807/2 "2017-07-12T23:54:42Z")

</div>

> [@xavi23](#):
>
> If I load always the patient data in all json, I have duplicate data innecessary.

I wish this was unnecessary, but since elasticsearch doesn't support joins and Kibana doesn't support parent child or nested, it actually is necessary.

---

<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: [August 9, 2017, 11:55pm UTC](https://discuss.elastic.co/t/filter-dashboard-from-different-json/92807/3 "2017-08-09T23:55:10Z")

</div>

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