Forum Discussion
Collating tricky data
Many thanks
KITSONA Like Hans, my first file averaged the half hourly numbers for each hour. I guess we weren't clear on what you asked for. The attached file contains a revised summary that first sums total KWh for each hour and then averages these hourly totals for each hour of the day. In PQ you can group records on whatever criteria you choose. As long as you have a column in your table to refer to. The advantage of PQ, in my view, is that for data you are dealing with, it's very easy to create new columns by extracting date and or time segments from a date/time column.
For more complex models, where you'd add a Calendar table that creates a date hierarchy that you can then use in pivot tables. So, in summary, with PQ and PP you can achieve everything that you can achieve with regular PT's and much more.
Hi Riny_van_Eekelen thanks for your contribution and showing me different tools I can use.
I have never used PQ before, so may have some learnings to do.
The reason I am collating this data is I am trying to show what size solar system these people need. So the ideal situation is for me to trade off their usage data with production data. Happy to attach that if you are willing to challenge yourself?
After that, the best scenario for me is to use what you have provided as a template for what I need to do for other people.
Let me know if you are keen to challenge yourself by overlaying this with generation data?