I have some meters (Day 0) that accumulate during the Day and ~midnight, the Day 0 zeros out and Day 1 becomes the value of the accumulator at Switch time.
What we want though is to create an analysis an get a result of "Inferred rate"
Something more like this.
Problem is, is I cant get a smooth trend because at midnight we catch a zero or a very low value.
Currently using this calc
Anybody already doing this out there that can help?
Thanks in advance..