How to calculate Count and percent of the total?

Hello, 

How do I go about answering these questions in Looker?  is there anyway to get  the total count and percent of the total from this data set  in Looker?

5de7440c-92f9-4699-b915-21e231e1d325.png
1 1 3,214
1 REPLY 1

Dawid
Participant V

Yes, there is a way. Depending on what kind of aggregation you need, or not. Once you have your data in Looker and model it, we can then help you better but the universal part would be to enable TOTALS on your dataset and then add Table Calculation ${field} / ${field:total} or even simpler ${field} / sum(${field}

If you want to create measures of all the points on your list you can do that using measures + filters.

https://help.looker.com/hc/en-us/articles/360001285947-How-to-Calculate-Percent-of-Total

Top Labels in this Space
Top Solution Authors