Hi usually export the daily generation data (done monthly), and the total would be by day. It now appears to be hourly. Complete nightmare and totally unusable without having to spend time consolidating it all.
I can't work out a way to get my daily total.
Any advice?
Mg151 look in the givenergy portal and just take the daily total figure for midnight each day
bit labour intensive if you want to transpose into a spreadsheet for a whole month
or if you just want monthly generation figures (which is all I collect) I just look at the last solar generation total on the last day of the month, e.g. 23:55 28/2/25 and subtract from it the same from the previous month 23:55 31/1/25
or use the ‘all data’ API and just look at the last entry before midnight if you want daily data
Or, if you're into spreadsheets, download a month's worth of data from the GE portal Energy Graph (Legacy), enter 1 into eg J2 and fill down to J29 with the numbers 1 to 28 (for eg Feb), put a formula such as '=SUM(B$1😮FFSET(B$1,($J248),0))+SUM(C$1😮FFSET(C$1,($J248),0))+SUM(D$1😮FFSET(D$1,($J2*48),0))-SUM(K$1:K1)' into K2 and copy down to K29. Use 24 rather than 48 if your data is hourly rather than half-hourly like mine. Columns B to D in the download are the solar outputs, so that should give you the month's daily totals for generation.
OK - in the formula a smiley-face = ':' + capital letter O and it's missing a couple of asterisks (multiplication signs) between $J2 and 48, for some reason (the third asterisk is there - why not the first two?) [ 😂 ]
I'll see if the forum accepts a screenshot...
Formula view:
