So I want to make a visualization in looker where i can expand and compress the table similar to what we can do in Looker Studio. I know on Drill but i don't want to use it as it opens up a different window for the visualisation but i want the expanding of the table inplace only. Please guide me if there is a way we can achieve this.
Thanks
Solved! Go to Solution.
Hi!
I think what you are looking for is using a subtotal table in Looker, here is the documentation
You can also set the subtotals to default to collapsed in the Edit->Series menu
Here's an example, where I've set country to collapse by default then clicked on "United Kingdom" to expand it: