Calculate Standard Deviation and Percentiles by Country

  • 19 January 2023
  • 1 reply

How can I get a table where I can see the country code, the count of accounts created and the standard deviation, 75th percentile, 25th percentile by country? 


I have been trying to do it but I can´t for the life of me get how to do it. I have tried creating measures on LookML but they didn’t work.

1 reply

Hi Andrea_gr, 


Create a Look with your country code and the count of accounts created. Then add a table calculation and refer to the Looker Functions and Operators documentation page

You could create a table calculation like so to find your standard deviation:


There is also a percentile function.


Hope this helps