@cortlieb
For the acceptable solution, I don’t think you need to group by time since you are basically just asking for the raw data, so you could use:
SELECT RainCorrDiff FROM coop_garden_calcv WHERE $timeFilter
To test, I generated some line protocol using this python (sample between 0 and 10 every 10 minutes for 24 hours at 13 minutes past the hour):
from random import randrange
# Monday, 21 October 2024 00:13:00
epoch = 1729469580
i = 0
str = ""
while i < 6 * 24:
rain = randrange(0,10,1)
str += f"coop_garden_calcv RainCorrDiff={rain} {epoch}\n"
# increment 10m
epoch += 600
i += 1
print(str)
Which you can see here, you can use the inbuilt grafana total to add all the values for you to see the total over the selected period:
If the range of time gets big, you would want to keep the minimum interval to 10m rather than letting grafana choose for you:
Hope this helps,
Thanks,
Tom
