Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- time_bucket_gapfill('10 minutes', "time") AS "time",
- entity_id,
- MAX(state::float) as "value"
- FROM ltss
- WHERE
- $__timeFilter("time")
- AND entity_id LIKE '%ruuvitag%_temperature'
- AND state NOT IN ('unknown', 'unavailable')
- GROUP BY time_bucket_gapfill('10 minutes', "time"), 2
- ORDER BY 1,2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement