I’m trying to set up Action Engine skills using standard deviations from KPIs to trigger the firing. However, it’s not the Action Engine part I’m having trouble with, it’s the standard deviation calculation.
Essentially I’m trying to calculate the standard deviation of client abc’s cancellation % from all clients’ cancellation %.
I’ve experimented with the STDEV function but because the cancellation % function already has AVG (an aggregate) it doesn’t work.
AVG(CASE WHEN “AuthMgmt_Tasks”.“auth_outcome” IN (‘Cancelled after work’,‘Cancelled prior to work’)
THEN 1.0 ELSE 0.0 END)
Hoping someone has experimented with this before, appreciate any help!