...
In FROM use the
one_month
RP and themgmt_api_requests
name,change the SELECT parameters to use field
count_requests
and the function tosum()
since we now need to add the counts up.
...
The equivalent query is: SELECT sum("count_requests") FROM "one_month"."mgmt_api_requests" WHERE $timeFilter GROUP BY time($__interval), "path" fill(0)
.
The graph now shows the expected correct values. You should change the Min interval to 5m
to match the CQ, and to visualise that the data covers a 5 minute period.
...