Knowledge Drop

Do average and median measures ignore nulls?

Userlevel 5
  • 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!