# Unable to Visualize Certain Nested Fields

**URL:** <https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494>\
**Category:** Kibana\
**Created:** [October 21, 2019, 2:10pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494 "2019-10-21T14:10:29Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![planetracer](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@planetracer](https://discuss.elastic.co/u/planetracer)\
**Post date:** [October 21, 2019, 2:10pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/1 "2019-10-21T14:10:30Z")

</div>

I have the following nested data in my index:

 ![SS%20Discover](https://us1.discourse-cdn.com/elastic/original/3X/3/3/33daa0ae808f6e778b79ade047b065adf5f1195f.png)

But when I try to visualize it, it doesn't find it:

 ![SS%20Visualize](https://us1.discourse-cdn.com/elastic/original/3X/2/f/2f7376f6053531c3c627a4646bd2e07c2af47bc8.png)

I was wondering if I was doing something wrong? Is there a way to fix this?

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 21, 2019, 2:47pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/2 "2019-10-21T14:47:48Z")

</div>

Hi @planetracer,

could you post the mapping of your index and the actual request and response your example visualization is creating here? You can get the request and response by clicking the "Inspect" button in the menu and selecting "Requests" in the top right of the flyout.

---

<div class="post-metadata">

**Author:** ![planetracer](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@planetracer](https://discuss.elastic.co/u/planetracer)\
**Post date:** [October 21, 2019, 3:02pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/3 "2019-10-21T15:02:53Z")

</div>

Of course!

This is the request:

 ![ss%20request](https://us1.discourse-cdn.com/elastic/original/3X/2/2/2276b61524331d85779a6cfb7d257a0d9c28beb4.png)

The response is fairly long, so I just included the part with individual-package-categories:

 ![SS%20Request](https://us1.discourse-cdn.com/elastic/original/3X/a/3/a3759c2f1d3508353c2f2434e979f6bc9536da97.png)

The mapping is also long, so I included the part with individual-package-categories as well:

 ![SS%20Mappings](https://us1.discourse-cdn.com/elastic/original/3X/4/0/4064d78438478340f503aa2beaef10fd9cda55e3.png)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 21, 2019, 4:14pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/4 "2019-10-21T16:14:21Z")

</div>

@planetracer It looks like this is request and response of the search in discover, not the visualization. Could you add request and response of the visualization?

---

<div class="post-metadata">

**Author:** ![planetracer](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@planetracer](https://discuss.elastic.co/u/planetracer)\
**Post date:** [October 21, 2019, 4:21pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/5 "2019-10-21T16:21:10Z")

</div>

Sorry about that! Here it is:

 ![ss%20rep%20vis](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c68e1f62f9f2c0a01aad84ccfb91ab60be2ec35b.png) ![ss%20req%20vis](https://us1.discourse-cdn.com/elastic/original/3X/6/3/6399152cf60e829163b61aa2add7537740a353ab.png)

---

<div class="post-metadata">

**Author:** ![planetracer](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@planetracer](https://discuss.elastic.co/u/planetracer)\
**Post date:** [October 22, 2019, 2:02pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/6 "2019-10-22T14:02:34Z")

</div>

I was wondering where I'm going wrong with this?

---

<div class="post-metadata">

**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\
**Post date:** [October 22, 2019, 2:08pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/7 "2019-10-22T14:08:48Z")

</div>

Kibana does not support aggregation on nested fields  
Check this link [https://www.elastic.co/guide/en/kibana/7.4/nested-objects.html](https://www.elastic.co/guide/en/kibana/7.4/nested-objects.html)  
Github issue : [https://github.com/elastic/kibana/issues/1084](https://github.com/elastic/kibana/issues/1084)

---

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [October 22, 2019, 2:37pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/8 "2019-10-22T14:37:29Z")

</div>

@ylasri is right about that. If you don't care about the relationship between an activity and its duration within a single document, you can consider not using nested objects here (with some pitfalls - e.g. you won't be able to get the duration for a single activity or split by activity). Another option would be to de-normalize and ingest each activity as a single document.

---

<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:** [November 19, 2019, 2:37pm UTC](https://discuss.elastic.co/t/unable-to-visualize-certain-nested-fields/204494/9 "2019-11-19T14:37:35Z")

</div>

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