Question

How to calculate Count and percent of the total?

  • 5 June 2021
  • 1 reply
  • 20 views

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?

 


1 reply

Userlevel 6
Badge +1

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

Reply