Question

Calculate Standard Deviation and Percentiles by Country

  • 19 January 2023
  • 1 reply
  • 12 views

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:

stddev_pop(${accounts.count_of_accounts})

There is also a percentile function.

percentile(${accounts.count_of_accounts},0.25)

Hope this helps

Reply