Hi!
I'm having a hard time getting pivot tables in Looker to show some data. My Google sheets data has only text values and I'm trying to get Looker to show the percentage of a text value in a given column.
For example, the percentage of text value A that is "yes" and then add additional text values as metrics, text value B, etc.
Hope that made sense. I can do this pretty easily in Google sheets pivot tables but can't figure it out in Looker.
Thanks!
Possible to share more details? Like how does your text value look like? Can you share a snap of the expected outcome in excel?