MEANDEVIATION()

Aggregate. Returns the mean absolute deviation (the mean of the absolute value of the deviations from the mean of all values) of a given expression over multiple rows.

Syntax

MEANDEVIATION( [DISTINCT] expression )

Data Types
Return	expression
Float	Integer
	Long
	Float
Interval	Interval
Interval	Timestamp

Example

The following example returns the mean absolute deviation of values in the temperature column:

INSERT INTO OutStream
SELECT MEANDEVIATION(Devices.temperature)
FROM Devices KEEP 24 HOURS;