Sprinkler System and Grafana

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.

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

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

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

This is not the grafana help service.

ok thanks for your help

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