Finding Past Anomalies
Learn to backtest anomaly detection by calculating mean and standard deviation with SQL window functions. Understand how to apply z-score thresholds dynamically on past data for improved detection results.
We'll cover the following...
We'll cover the following...
In the previous section, we identified an anomaly. We found an increase in the 400 status code because the z-score was 6. But how do we set the threshold for the z-score? Is a z-score of 3 an anomaly? What about 2, or 1?
To find thresholds that fit our needs, we can run ...