
1. Re: Secondary Table Calculation using different value details
Zhouyi Zhang Dec 9, 2017 4:44 AM (in response to Wolfgang Lukaschek)Hi, Wolfgang
I hope I understand your requirement correctly. Please see my below result and attached workbook.
Hope this could help
ZZ

2. Re: Secondary Table Calculation using different value details
Wolfgang Lukaschek Dec 9, 2017 10:16 AM (in response to Zhouyi Zhang)Thanks Zhouyi!

3. Re: Secondary Table Calculation using different value details
Wolfgang Lukaschek Dec 11, 2017 8:20 AM (in response to Zhouyi Zhang)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?

4. Re: Secondary Table Calculation using different value details
Zhouyi Zhang Dec 12, 2017 9:54 PM (in response to Wolfgang Lukaschek)Hi, Wolfgang
Can you provide what you have done so far so that I could take a look.
ZZ