Hello I’m dummy on Grafana/InfluxDB. I succeed to deploy them to collect data from an energy counter that generates a pulse every [Wh] produced. This number of pulse is recorded in Influx via MQTT. When I launch the command to display all the data from the 10 last seconds with select * from ESP_…

Hello, I have used below link to calculate total home energy consumption from KW information as provided by inverters. [image] Properly Displaying Power Consumption from kW to kWh Configuration Hi, Wanted to first off say Thanks to all who put in work to make Grafana happ…

thank you ! Do you know how do I compute the sum of a value from the begining of the ongoing year ? SELECT sum(“value”) as conso FROM “sensors”.“autogen”.“ESP_Eau” WHERE “topic”=‘ESP_Eau/Compteur_Eau_Pluie/Count’ AND time>(now/y) does not work but this one works, only for this year as hardcoded… …

i think that query is correct SELECT COUNT(“value”)*60 FROM ESP_Chaudiere WHERE topic=‘ESP_Chaudiere/Production_Photovoltaique/Count’ AND time > now()-60s ORDER BY DESC

this count number of values the last 60 seconds. My objective was to sum all values from 1/1/ongoing-year

Sorry i was confused SELECT COUNT("value")*60 FROM ESP_Chaudiere WHERE topic=‘ESP_Chaudiere/Production_Photovoltaique/Count’ AND $timeFilter ORDER BY DESC [image] note “Relative time: 1y/y”

Solar panel energy counter: show real time power

Grafana InfluxDB

dmiinc April 7, 2020, 1:57pm 2

Hello, I have used below link to calculate total home energy consumption from KW information as provided by inverters.

I am thinking it will work for you.

Topic		Replies	Views
Properly Displaying Power Consumption from kW to kWh Configuration	19	32557	January 5, 2022
Sum up values from solar panels Grafana	9	3059	July 28, 2022
Bar graph from momentarily Watt-Values InfluxDB	3	1667	January 22, 2020
Daily power consumption from watts InfluxDB	35	44399	April 21, 2023
Extract Daily Values InfluxDB	4	13726	November 13, 2017

Solar panel energy counter: show real time power

Related topics