Summarize Data per Day

[kusihub]

Hi there

I'm new to Grafana. Therefore excuse me if this is not something this plugin should be able to do. However, i have a rest api that provides a series of time events with values. for exmaple

10.10.2023 11:00 45
10.10.2023 11:03 20
etc.

I would need a daily sumarized value of these events. Is it possible to do this with this plugin? i searched a lot, found sql queries that could do this, but i don't get how i can manipulate the data recieved and interpreted by json api plugin using sql.

thank you for your time and have a nice day
cheers
markus