MOVING_TRIMMED_MEAN
Description
Calculates the trimmed mean with a cut off of 10% for each window. It can be applied to INT or FLOAT columns.
Syntax
MOVING_TRIMMED_MEAN ( 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 trimmed mean for current row and one row above. Window is too small to do any trimming. Therefore the result is the same as for an average. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[2] Moving trimmed mean for current row and one row above with null values. Window is too small to do any trimming. Therefore the result is the same as for an average. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] Moving trimmed mean for current row and one row above. Window is too small to do any trimming. Therefore the result is the same as for an average. A FILTER is applied, such that only rows with an INCOME value less than 500 are taken into account. | ||||||||||||||||||||||
| ||||||||||||||||||||||
|