Hello,
im absolutely lost at the moment.
I have a table with two colums:
Date and Value
2022-09-12 22:35:01 10
2022-09-12 22:35:11 20
…
So what I need:
a) The sum of all values of the actual day
b) The count of values per day
c) as result: a)/b) (Sum of all values per day / count of values)
How can I do that with grafana and InfluxDB als Source?
Thanks!
welcome to the forum, @warhammer73
this should all be possible from within the panel editor by using Transformations. Specifically check out the add field from calculation
transformation
however, it sounds like you also want to take data and group it by day, and for that you should search this forum. Lots of great threads about influx data that folks want to aggregate / group on a per-day basis