This post describes how to set alerts when the control limits are not constant.
In the viz above, we want to set alerts when the moving average line (grey line) is above Upper Control Limit or below the Lower Control Limit (red lines). The challenge is the control limit lines are not constant but changing by the day.
The work-around solution is to create another worksheet ‘Alerts’, write a calculated field, and add it to the dashboard.
@Alert
If ([Moving Avg] > [UCL] OR [Moving Avg] < [LCL]) THEN 1 else 0 end
Then set alerts on the y-axis of the Alerts worksheet when @Alert = 1.
