Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. SELECT integral("value",1h) / 1000 FROM /(Klima|NAS)_Power/ WHERE time > now()-1w AND time <= now() GROUP BY time(1d) fill(null)
  2.  
  3. name: Klima_Power
  4. time integral
  5. ---- --------
  6. 2019-07-11T00:00:00Z 0.0028576888333333326
  7. 2019-07-12T00:00:00Z 0.05559535705833335
  8. 2019-07-13T00:00:00Z 0.055475250270833325
  9. 2019-07-14T00:00:00Z 0.0551049064541667
  10. 2019-07-15T00:00:00Z 0.055454312898611136
  11. 2019-07-16T00:00:00Z 0.05580957162916666
  12. 2019-07-17T00:00:00Z 0.05551291632777774
  13.  
  14. name: NAS_Power
  15. time integral
  16. ---- --------
  17. 2019-07-11T00:00:00Z 0
  18. 2019-07-12T00:00:00Z 0
  19. 2019-07-13T00:00:00Z 0
  20. 2019-07-14T00:00:00Z 0
  21. 2019-07-15T00:00:00Z 0
  22. 2019-07-16T00:00:00Z 0.1073428686286408
  23. 2019-07-17T00:00:00Z 0.7449990083701262
  24. 2019-07-18T00:00:00Z 0.756581078140122
  25.  
  26. name: Klima_Power
  27. time integral
  28. ---- --------
  29. 2019-07-18T00:00:00Z 0.05271264777916669
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement