Common queries

Compare the last measurement to another bucket's mean

Compare the value from the latest point to an average value stored in another bucket. This is useful when using the average value to calculate a threshold check.

Find and count unique values

Count the number of unique values in a specified column.

Recalculate the _value column

Recalculate the _value column without creating a new one.

Use values to calculate a new column

Use the map() function to create a new column calculated from existing values in each row.

Use multiple fields in a calculation

Query multiple fields, pivot results, and use multiple field values to calculate new values in query results.