Hi all, apologese if this is in the wrong forum, I’m new to this and have come asking for help after trying to make sense of this for just over a day now!
I am storing requests per-second from my service for displaying in Grafana, the data, along with the information on the service, method, etc. has a result.
If possible, I’d like to display this data in a Grafana graph with each result type, and hovering over this graph will show the request count of each method.
I have the following query, and I’ve looked into transforming the data, but I just can’t seem to get anywhere with it.
Here’s the Flux query:
from(bucket: "<bucket>")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["service.name"] == "<service>")
|> filter(fn: (r) => r["method"] == "<method>")
|> filter(fn: (r) => r["_field"] == "counter")
|> filter(fn: (r) => r["_measurement"] == "<method>/request_counts")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean")
Hoping someone here can point me in the right direction.
