Hi, I’m having difficulty figuring this one…
I have an ever-increasing value (Kwh) stored and I want to know by how much it increased in 7/14/30 days. I currently have 20-ish days of data stored.
this is my current query and it seems to work for 7d, but not for 14 or 30. What aggregator/selector am I suppose to choose for this?
I’m getting the time using the group by in the query, is this okay or should I use the relative time instead?
Thanks for the help.