Common queries

The following articles walk through common queries using the NOAA water database data.

Operate on columns

Find and count unique values, recalculate the _value column, and use values to calculate a new column.

Use multiple fields in a calculation

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

Comparing values from different buckets

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.

IoT sensor common queries

Use Flux to address common IoT use cases that query data collected from sensors.

This list will continue to grow. If you have suggestions, please submit them to the InfluxData Community.