Knowledge Drop

Do average and median measures ignore nulls?


Userlevel 5
Badge
  • Looker Staff
  • 172 replies

Last tested: Feb 12, 2018

 

Yes, they do.

This means that if you had the numbers 1,2,3,null,null then Looker's median and average would both return 2 rather than 1 or 1.25 .

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply