ZZ, I have another question related to the result of this calculation.
How may I plot this on a graph? When I visualize it, the Calculations appear to be using data from "across" rather than "down" for the first of the 2 calculations.
The attached screenshot shows the original value (Total kWh) and the 2 calculations. From what I see Calculation 1 (red) that is supposed to use the last previous 10 days for each specific hour of the day seems to be plotting a 10 hour average, i.e. computes "across" rather than using the results from the "compute down" in the table.
Any advice you can give on how I could simply use the results of the table calculation and plot them?
Can you provide what you have done so far so that I could take a look.