Common queries
The following articles walk through common queries using the NOAA water database data.
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.
This list will continue to grow. If you have suggestions, please submit them to the InfluxData Community.
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.