Daily sum of hours with measurement greater x

InfluxDB 1 InfluxQL
,
2

Hi @mimo and welcome to the InfluxData forum.

Here is an example in Grafana using InfluxQL that I created which appears to be similar. If we modify the query to be only Texas with a value > 5000 like this:

SELECT sum("value") FROM "ElectricPowerOperations" WHERE ("type"::tag = 'Demand' AND "region"::tag ='Texas') AND "value" > 5000 AND $timeFilter GROUP BY region, time(1d)

then the daily bar graph looks like this:

image
image1084×300 13.1 KB

and table like this:
image