How to make compressible table in Looker from visualisation?

[Ashish_Vats]

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 

[looker_ant · Accepted 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:

[Ashish_Vats]

Is there any other way of doing this. Like in looker studio. I am here by sharing the link of the demo of the compressible table.
Link:<PII removed by staff>

[looker_ant]

It looks like your link got removed.

If you are talking about the expand collapse functionality described in this Looker Studio Doc, then Looker's subtotal as I described is the closest thing. 

Out of curiosity, is there a reason the subtotals in Looker doesn't quite work for you, or why you prefer the Looker Studio expand-collapse?

[hugo-pena]

Hi!

Just like the OP, I also wanted to use the 'expand-collapse' view, but only subtotals are available for me.

I prefer the 'expand-collapse' view for two reasons:

It’s clearer and cleaner in showing how the hierarchy is applied (e.g., Americas > Northern America > Canada) through the use of background colors. With subtotals, each row has a different color, even for higher-level hierarchies which makes it harder to follow.

I'm not sure how totals are displayed in 'expand-collapse', but in the subtotals view, the total appears inline with the hierarchy label, which I find confusing. Typically, I expect the total to appear at the bottom of the group.

[looker_ant]

Got it! 2 options for you:

Try playing around with Table calculations to get the desired effect:
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Subtotals-with-Table-Calculations/ta-p...

Use Studio in Looker with Looker as the data source and then you can use Studio visualizations backed by data coming from your LookML model.