Good morning everyone,
I have a system that records the instantaneous power (W) on the influxdb database about every 20 seconds. The interval is not accurate, sometimes 21/22, sometimes 18/19… I would like to calculate the Daily energy consumption on a histogram… what is the correct query to use?
Actually i’m using this query but the results isn’t accurate… I need to find a correct query to fetch a best result
SELECT mean(“mean”)*24 FROM (SELECT mean(“pdc_p1_input_power”) FROM “KWh” WHERE (“pdc_p1_prod_acs” = 0 AND “pdc_p1_defrosting” = 0) AND $timeFilter GROUP BY time(20s) fill(0) tz(‘Europe/Rome’) ) GROUP BY time(1d) fill(0) tz(‘Europe/Rome’)