# Drill down visualization for json data that contains nested structure

**URL:** <https://discuss.elastic.co/t/drill-down-visualization-for-json-data-that-contains-nested-structure/264173>\
**Category:** Kibana\
**Created:** [February 12, 2021, 7:26pm UTC](https://discuss.elastic.co/t/drill-down-visualization-for-json-data-that-contains-nested-structure/264173 "2021-02-12T19:26:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kinnub](https://avatars.discourse-cdn.com/v4/letter/k/d6d6ee/32.png) [@kinnub](https://discuss.elastic.co/u/kinnub)\
**Post date:** [February 12, 2021, 7:26pm UTC](https://discuss.elastic.co/t/drill-down-visualization-for-json-data-that-contains-nested-structure/264173/1 "2021-02-12T19:26:09Z")

</div>

Continuing the discussion from [Drill Down Visualization](https://discuss.elastic.co/t/drill-down-visualization/245413):

I am looking for a solution and my use case is similar to the discussion (above link ). Could you please let me know if there is any solution/workaround for it?

My sample data looks like below:

```auto
 {
 "Name":"L1",
 "Number of requests": 30,
   "level1":[
         {
            "Name":"L2",
            "Number of requests": 40,
             "level2":[
                   {
                      "Name":"Ln",
                      "Number of requests": 60,
                      "leveln":[
 
                        ]
                        }
            ]
         },
       ]
 
 }

```

So, I need to create a visualization that shows the no.of requests at each level.  
The first pie chart would have only one entry - L1 and the count (no.of requests) is 30.  
If we click on L1, it should show all the Level 2 names and their corresponding "no.of requests" in the pie chart. Is this drill down possible? (or) I am ok to have several pie charts in the same dashboard and enable to show only the specific linked levels when one is clicked in the pie chart (enabling filters that would filter respective level names and their counts).

Any ideas/suggestions are greatly appreciated.

Thank you!

---

<div class="post-metadata">

**Author:** ![Patrick\_Mueller](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_mueller/32/109425_2.png) [@Patrick\_Mueller](https://discuss.elastic.co/u/Patrick_Mueller)\
**Post date:** [February 22, 2021, 4:52pm UTC](https://discuss.elastic.co/t/drill-down-visualization-for-json-data-that-contains-nested-structure/264173/2 "2021-02-22T16:52:45Z")

</div>

Kibana doesn't have a lot of visualization support for the `nested` mapping field, which is I assume is what you would be using for this data. Usually it's easier to have all the data denormalized into individual documents, and then use aggregations for the visualizations.

---

<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 22, 2021, 4:52pm UTC](https://discuss.elastic.co/t/drill-down-visualization-for-json-data-that-contains-nested-structure/264173/3 "2021-03-22T16:52:57Z")

</div>

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