Trending with raw queries
Why use a raw query?
- Allows advanced filtering, transformations, and calculations not yet available in the visual query editor.
- Useful for very specific data needs, or when replicating queries from another system.
Example
SELECT mean("value")
FROM "temperature_sensor"
WHERE time >= now() - 24h
GROUP BY time(1h) fill(previous)This query fetches hourly average temperature values from the last 24 hours, filling gaps with the previous value.
Query reference
For detailed syntax, refer to the official query language docs: