Hi there,
I have a bar graph of multiple items ordered by quantity and I want an alert to be able to catch any item that surpasses a certain amount sold. I would like this alert to stay on the dashboard but only return the results of the one bar or bars that broke the goal line when updated and not keep returning the results of every option that has already broken past that amount.
I've tried setting up a side question to also limit it by saying exclude results that are 10 over the goal but that will either instantly remove them if a large order is put through or if they stay at 1008/1000 then they'll keep getting caught in the alert.
Is there anyway Metabase can work with an alert to maintain a bar graph structure but only report on when the group reaches the goal for the first time?
Thanks