# Datatable/Discover Drilldown to child elements

**URL:** <https://discuss.elastic.co/t/datatable-discover-drilldown-to-child-elements/205816>\
**Category:** Kibana\
**Created:** [October 30, 2019, 9:36am UTC](https://discuss.elastic.co/t/datatable-discover-drilldown-to-child-elements/205816 "2019-10-30T09:36:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![j\_a\_griffiths](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/j_a_griffiths/32/54323_2.png) [@j\_a\_griffiths](https://discuss.elastic.co/u/j_a_griffiths)\
**Post date:** [October 30, 2019, 9:36am UTC](https://discuss.elastic.co/t/datatable-discover-drilldown-to-child-elements/205816/1 "2019-10-30T09:36:13Z")

</div>

I have some data in an index similar to below

Name - This is a string  
id - This is an integer  
childid - This is a csv list of integers stored in a string

So I may have  
"Jon", 1, "2,3"  
"James", 2, ""  
"Lisa", 3, ""  
"Bert",4,""

Where James and Lisa are children of Jon, Bert has no child elements

I want to be able to discover all documents which have child id's (simple enough)

But I then want to be able to click/drill down on the child id's to list the documents that have id's matching one of the csv values in Jon so in the above case id=2 or 3

Ideally I would like to visualize JOn/James and Lisa all in one place if I select the child ids on jon

Is there any way of doing this with Discover/Data tables or any other parts of kibana

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [October 31, 2019, 9:20pm UTC](https://discuss.elastic.co/t/datatable-discover-drilldown-to-child-elements/205816/2 "2019-10-31T21:20:16Z")

</div>

No, we haven't built this in to Kibana. You may want to look for a Kibana plugin such as [https://github.com/flexmonster/pivot-kibana](https://github.com/flexmonster/pivot-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:** [November 28, 2019, 9:20pm UTC](https://discuss.elastic.co/t/datatable-discover-drilldown-to-child-elements/205816/3 "2019-11-28T21:20:24Z")

</div>

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