Can signoz provide percentage query and monitoring...
# general
r
Can signoz provide percentage query and monitoring? For example, the number of successes divided by the total number, wait to do the proportion of monitoring and reporting. @nitya-signoz
s
You, you can do this. For example, if you take the span metrics generated by SigNoz from metrics, there is a metric called
signoz_calls_total
that contains attributes
status_code
. You can use
SUM_RATE(signoz_calls_total)
where
status_code!=STATUS_CODE_ERROR
for the total successful operations. And divide it by
SUM_RATE(signoz_calls_total)
without any filters
r
I mean when we use log metrics is easy。
image.png
it is hard to write sql when use percentage query。
s
I didn't understand your point. The same thing should work for logs as well. The query A will be used for success and query B will be used for total and you can use formula
A/B
for percentage.
r
ok. i get . I going to try formula
A/B