Sprinkler System and Grafana

Configuration
1

I have posted in Grafana Communit but got no response.
I have not seen a good tutorial on grafana. So I like to ask you guys to help get me started

So I using my Sprinkler System an when turn on it send data to influxdb as 1 with an time and 0 when it turn off with a time.

so what i like to do is use grafana to tell me how much water was give IN the time. (Eg I worked out that Sprinkler1 do 100ml a min and Sprinkler2 do 200ml a min.
I have started an graph but shows just 1 every time it turn on and drops when it turn off

what I think with the youtube video’s I have watch that is something to do in Metrics “SELECT” OR “GROUP_BY”

I been looking how to use the integral function but can’t find anything that helps me understand.

2

I don’t see a mention of home assistant in your post?

3

Ok what do you mean, will you like to know what I using??

4

Can you help as Grafana Communit could not help or there Grafana Communit is not helpful

5

This is not the grafana help service.

6

ok thanks for your help

7

if any one els can help me I happy for help. I also see other topic
“Show Grafana Graphs in Home-Assistant” are ok to post.
Thanks Aaron