Accumulate Rain Values at specific time

  • What Grafana version and what operating system are you using?
    V.8.1.2 Debian Linux

  • What are you trying to achieve?
    3 Singlestats with weekly, monthly, yearly rain accumulation

  • How are you trying to achieve it?
    Find out how to create a query that can add up values from specific timepoints

  • What happened?
    My Weatherstation creates a measurement in my influxdb where it accumulates the rainfall over the day. At 24 o’clock it resets it’s rain counter to zero.
    To achive Single-Stats with weekly, monthly, yearly accumulation i have to sum up the daily values at 23:59:59
    How can i achieve that?

Thank you in advance.