So, let's go... I need the average to be cyclical. I noticed that this "Historical Statistics" tag calculates the average of the entire variable. It's like going from "point A" to "point B" = average (A and B). Then, it will present another cycle... "point C" to "point D," and so on.
The value of this average will be generated by Excel. I'll take some random numbers as an example, so you can visualize.
Cycle 1 (red) = Average (15, 20, 30, 10) = 18.75
No values (values zero and less than 0 do not appear).
indicated in gray.
Cycle 2 (green) = Average (12, 75, 36, and 23) = 36.5
No values (values zero and less than 0 do not appear) - indicated in gray.
And so on.
And at the end of each cycle, calculate its average. When it reaches 0 or less, it indicates a new cycle.
I'm racking my brain for a solution.
So, let's go... I need the average to be cyclical. I noticed that this "Historical Statistics" tag calculates the average of the entire variable. It's like going from "point A" to "point B" = average (A and B). Then, it will present another cycle... "point C" to "point D," and so on.
The value of this average will be generated by Excel. I'll take some random numbers as an example, so you can visualize.
Cycle 1 (red) = Average (15, 20, 30, 10) = 18.75
No values (values zero and less than 0 do not appear).
indicated in gray.
Cycle 2 (green) = Average (12, 75, 36, and 23) = 36.5
No values (values zero and less than 0 do not appear) - indicated in gray.
And so on.
And at the end of each cycle, calculate its average. When it reaches 0 or less, it indicates a new cycle.
I'm racking my brain for a solution.

edited 2 days ago at 1:28 am