This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
for the measure, it might be useful to include IGNORE NULLS to ensure
that the median is calculated as intended. For example, sum(value) and
avg(value) ignore nulls. Similarly, it would make sense for
median(value) to do the same. MEDIAN(ARRAY_AGG(${...