Add all values of a day and display the result

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 :grafana: 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 :+1: