Do average and median measures ignore nulls?

[sam8]

Knowledge Drop

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.