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.
Was this page helpful?
Thank you for your feedback!
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, use the following resources:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.