Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT integral("value",1h) / 1000 FROM /(Klima|NAS)_Power/ WHERE time > now()-1w AND time <= now() GROUP BY time(1d) fill(null)
- name: Klima_Power
- time integral
- ---- --------
- 2019-07-11T00:00:00Z 0.0028576888333333326
- 2019-07-12T00:00:00Z 0.05559535705833335
- 2019-07-13T00:00:00Z 0.055475250270833325
- 2019-07-14T00:00:00Z 0.0551049064541667
- 2019-07-15T00:00:00Z 0.055454312898611136
- 2019-07-16T00:00:00Z 0.05580957162916666
- 2019-07-17T00:00:00Z 0.05551291632777774
- name: NAS_Power
- time integral
- ---- --------
- 2019-07-11T00:00:00Z 0
- 2019-07-12T00:00:00Z 0
- 2019-07-13T00:00:00Z 0
- 2019-07-14T00:00:00Z 0
- 2019-07-15T00:00:00Z 0
- 2019-07-16T00:00:00Z 0.1073428686286408
- 2019-07-17T00:00:00Z 0.7449990083701262
- 2019-07-18T00:00:00Z 0.756581078140122
- name: Klima_Power
- time integral
- ---- --------
- 2019-07-18T00:00:00Z 0.05271264777916669
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement