MOVING_MEDIAN
Description
This function calculates the median for each window. It can be applied to any data type.
Syntax
MOVING_MEDIAN ( table.column, start, end )
NULL handling
NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL.
Examples
[1] Moving median for current row, one row above and one row after. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[2] Moving median for current row, one row above and one row after with null values. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] Moving median for current row, one row above and one row after. A FILTER is applied, such that only rows with an INCOME value less than 500 are taken into account. | ||||||||||||||||||||||
| ||||||||||||||||||||||
|