Hi Everyone,
I'm trying to build the following alert but I'm falling short, maybe I'm not seeing a simple solution in front of my eyes.
Tigger an hourly alert when :
Total discount on an order >= (revenue * 110%)
E.g. :
If an order has 200€ worth of merchandise, where 140€ is revenue and 60€is total discount ==> Do not trigger.
If an order has 200€ worth of merchandise, where 85€ is revenue and 115€is total discount ==> Do trigger.
Thus each hour an order like the last one is made, an alert should be sent.
NB : The total discount dimension and revenue dimension are "real dimensions", not calculated ones.
Is it possible to do with the current alert system?
I tried to implement a workaround similar to this one : Adobe Analytics Alerts or Creating Hourly Alert when Revenue = 0 from urs.boller but with no success yet.
Thanks !