Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having trouble with a KPI set analysis query.
I'm trying to get the average of all vulnerabilities over the SLA date that are open, in progress, and critical.
past_sla is a boolean (0 or 1).
avg({<[past_sla]={"> 0"}, [status]={"OPEN", "IN_PROGRESS"}>} If([severity]="CRITICAL",[vuln_age]))
Unfortunately, this query doesn't return anything but a hyphen, which I assume simply means error of some sort.
Any ideas what's wrong with the query? Thanks!
I belive it is your if condition statement that is causing you trouble.
Maybe this will help:
avg({<[past_sla]={"> 0"}, [status]={"OPEN", "IN_PROGRESS"},[severity]={"CRITICAL"}>} [vuln_age])
I belive it is your if condition statement that is causing you trouble.
Maybe this will help:
avg({<[past_sla]={"> 0"}, [status]={"OPEN", "IN_PROGRESS"},[severity]={"CRITICAL"}>} [vuln_age])
Thanks! That seemed to do it.