How to calculate AVG

Question & Answer
, , ,
7

Thanks so much for your help.
I got the answer using this

(countOver(
ifelse({compliance_risk} = ‘High’, {account_uuid}, NULL),
[truncDate(‘MM’, {activation_date})], PRE_AGG
)
/
countOver({account_uuid}, [truncDate(‘MM’, {activation_date})], PRE_AGG)) * 100

Thanks

2 Likes