Returns the median of the set of values defined as the absolute value of the difference between each value and the median of all values in each group.

MAD is a single-threaded function.

To invoke this function, use the GROUP BY TIME clause. For more information, see GROUP BY TIME Clause.

## Return Value

This function returns the REAL data type.

Nulls are not included in the result computation.

## Usage Notes

The formula for computing MAD:

If the constant_multiplier is not provided, it uses 1.4826 as the default.

MAD is valid only for numeric data.