Trouble with KPI set analysis query

[Tim_Griffith]

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!

[Vegar · Accepted solution]

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])

[Tim_Griffith]

Thanks! That seemed to do it.