Avatar

Level 2

Thanks for the idea

I tried 1) to 3) previously but not yet 4).

==> I just did it and created a "column sum discount exceeds revenue" calculated metric, then created an hourly alert on it to be sent everytime there is a 1% change on it. So far it estimates the alert should have triggered last Wednesday but I do not see any order ID qualifying to trigger it on that date. I'm not sure it is working but i'll let the alert on a few days to analyze the results

So, to be continued...
And thanks again for your help