Count and Sum all hours during a year which had a power comsumption over 5kW during 1h

I want to know all hours during the last year, which had a power comsumption over 5kW in this hour.

In addition i want to know what is the Sum of all this values.

  • Some values may be 1kW, some 2kW or 3kW above the 5kW

I am new in grafana, use this in homeassistant with influxdb.

Welcome

Are you using influxql or flux query language?

Hm … it is influxdb only installed on homeassitant, the grafana looks into this db.

I know mssql and so on, but i am using grafana the first time.

I can show a graph with an hourly comsumption but how to count or sum is not clear to me.

Influx Query like this:
SELECT mean(“value”) AS “mean_value” FROM “homeassistant”.“autogen”.“kWh” WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND “entity_id”=‘gas_meter_kwh’ GROUP BY time(:interval:) FILL(null)

Grafana Query like this:
SELECT mean(“value”) FROM “kWh” WHERE (“entity_id” = ‘gas_meter_kwh’) AND $timeFilter GROUP BY time($__interval) fill(null)

1 Like

So that influxql not flux query