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...