Setting custom alerts based on calculations
I've created the chart below where the line represents the running total number of sales and the bars represent the forecasted sale throughout the day. Would it be possible to create an alert that notifies users when the sum of sales is equal to or greater than the max forecasted sales value? Basicly setting an alert with forumlas rather than a hardcoded number. I thought about setting a binary field in the data to set off a trigger but then it seems as if it would have to be incorporated into the chart.