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
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 to show a bar for the country, broken down by the cities within.
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, ...).
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.