Sum values over the past hour

I’m currently logging successes/failures of something that happens every ~10 seconds.

My graph currently looks like this:

However, what I’m more interested in, is the number of successes/failures over the past hour. And eventually I’ll also compute the percent of that. That way, I can monitor whether we have an unusually high amount of failures.

I’m struggling to figure out how to approach this with Grafana. I’ve been looking at sumSeries() and integral() but I’m not sure if I’m looking in the right place. Tips would be appreciated!