Create matric for counter (rain counter: rain per/day as bar chart)

Grafana Elasticsearch
1

I am recording the amount of rain and this get logged in InfluxDB.

The data in DB are like a counter that get increased over time.

I would like to have a bar chart with the amount of rain per day.

Somehow I get a Graph (attached), but the Values are totally confusing me.

My challenge is, I do not understand how I need to setup the query to get the data right calculated and visualized per day.

Any Advice is highly welcome. (Pictures with metrics attached)

pic2_rain_counter_per_day
pic2_rain_counter_per_day1889×708 77.5 KB
sum
sum1698×749 71 KB

The problem I am having are the delta values per day.
The values per day are not correct.
Thank you in advance

Br

1 Like
2

If someone is interested in a solution:

I took the max and the min value per day and created the difference. (per day)

select max(value)-min(value) from OEQ2113585_1RAINCOUNTER WHERE $timeFilter GROUP BY time(1d) fill(null)

br

2 Likes
3

Hi,
I think you could also use the difference() function
https://docs.influxdata.com/influxdb/v1.7/query_language/functions/#difference

Calculate difference between the first (or last) measurement per day.

4

I am recording the amount of rain and this get logged in InfluxDB. The data in DB are like a counter cps test that get increased over time. Apache ECharts, a powerful, interactive charting and visualization library for browser. … Rainfall vs Evaporation … Clickable Column Chart with Gradient. To describe a complete solution it suffices to choose one particular solu- … Let’s find the complete solution to Ax