i am being challenged with an issue of alerts. I believe the alert feature is designed to provide alerts to recipients when the condition is initially not met. I am looking for a method to alerts recipients to alert recipients when the condition is already met.
Use case: Sales Growth
lets say for example we are currently at 95k sales a month (month 0) and set an alert at 100k. We do great next month (month 1) and reach 105k, the alert is sent out to recipients. Month (month 2) after we also have a great month at 110k. With my testing, the alert will not be sent to the recipient for month 2
When the alert is set, you should be able to configure it to run when the data is above or equal to the target set. On a weekly at most frequency, the alert should be sent for both Month 1 and Month 2 in your example. (see image below)