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 (CAST (attributes -> 'elevation' AS FLOAT)) as "value"
- FROM ltss
- WHERE
- $__timeFilter("time")
- AND entity_id = 'sun.sun'
- AND state NOT IN ('unknown', 'unavailable')
- GROUP BY time_bucket_gapfill('10 minutes', "time"), 2
- ORDER BY 1,2
Add Comment
Please, Sign In to add comment