# Kibana drill down fields **URL:** \ **Category:** Kibana\ **Created:** [March 29, 2022, 1:51pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970 "2022-03-29T13:51:29Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bianca6](https://avatars.discourse-cdn.com/v4/letter/b/85e7bf/32.png) [@bianca6](https://discuss.elastic.co/u/bianca6)\ **Post date:** [March 29, 2022, 1:51pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/1 "2022-03-29T13:51:29Z")
Hi, I have some logs like this: ```auto country = France, city = Paris, value = 6 country = France, city = Marseille, value = 2 country = Italy, city = Roma, value = 8 ``` In a Kibana dashboards, I can display the countries and sum their values. But how can I create a drill down (as there is Google Data Studio, Microsoft Power BI, ...) to change the view from "country" to "city"? Thanks! PS: an example from Data Studio: [Drill down into your data - Data Studio Help](https://support.google.com/datastudio/answer/9319405?hl=en) ---
**Author:** ![Dzmitry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dzmitry/32/65026_2.png) [@Dzmitry](https://discuss.elastic.co/u/Dzmitry)\ **Post date:** [March 29, 2022, 2:24pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/2 "2022-03-29T14:24:55Z")
Hi @bianca6 , Kibana has a [drill down functionality](https://www.elastic.co/guide/en/kibana/current/drilldowns.html) that makes dashboard intractable. You did not specify your Stack version, so I'm not able to confirm if it is supported. Still there are multiple ways to achieve your goal on older stack versions, e.g. using filters or for example creating a complex pie chart splitting it by country and city, or create [2 pie charts](https://discuss.elastic.co/t/resolved-kibana-is-it-possible-to-drill-down-the-pie-chart-view-other-related-information/197051) Let me know if I that helps you. Regards, Dima ---
**Author:** ![bianca6](https://avatars.discourse-cdn.com/v4/letter/b/85e7bf/32.png) [@bianca6](https://discuss.elastic.co/u/bianca6)\ **Post date:** [March 29, 2022, 2:38pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/3 "2022-03-29T14:38:39Z")
I'm using with version 8.0.0 And this is not what I meant by "drill down", on your link, the first part is a filter on "US" and the second one is an URL. I'm looking for something as a group by, which drill down the data (there are different levels as country and city) ---
**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\ **Post date:** [March 29, 2022, 2:55pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/4 "2022-03-29T14:55:58Z")
@devon.thomson can we please get some inputs here? I think input control is the way to go? Thanks, Bhavya ---
**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\ **Post date:** [March 29, 2022, 3:24pm UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/5 "2022-03-29T15:24:18Z")
Hey @bianca6, from what I've seen in the Data Studio Help link, this looks like a feature request for a new type of drilldown. Basically, this looks like an in-place chart-swap drilldown. On click, a new chart is rendered, replacing the last chart, in the same place on the dashboard. This new chart is filtered by the value you clicked, and contains a different x and y axis. If this is close to what you're requesting, I can log an enhancement request! This doesn't quite suit your ask, but as a workaround you can configure [Lens charts](https://www.elastic.co/guide/en/kibana/current/lens.html) to show a bar for the country, broken down by the cities within. ---
**Author:** ![bianca6](https://avatars.discourse-cdn.com/v4/letter/b/85e7bf/32.png) [@bianca6](https://discuss.elastic.co/u/bianca6)\ **Post date:** [March 30, 2022, 8:09am UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/6 "2022-03-30T08:09:11Z")
Quite like this yes, not really a "filter on the value you clicked", in other words we can say it's a "zoom". Like on the same graph, I can zoom out to see the value per "continent", zoom in to see the value per "country" and zoom one more time for "city" without filter on a specific continent / country / city. Behind is something like a "group by" which change the main field (continent/country/city) and keep all the others fields (values, timestamp, ...). Thanks for all your answers 🙂 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 27, 2022, 8:09am UTC](https://discuss.elastic.co/t/kibana-drill-down-fields/300970/7 "2022-04-27T08:09:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.