Search⌘ K
AI Features
Home
Courses
Simple Anomaly Detection using SQL

Experiment with Different Values

Explore how adjusting key parameters such as lookback period, entries threshold, and z-score threshold affects anomaly alerts in SQL backtesting. This lesson helps you understand how to optimize these values to generate precise, actionable alerts from your data analysis.

We'll cover the following...

In the process so far, we’ve used several constants in your calculations:

  • Lookback period: How far back we calculate the mean and standard deviation for each status code. The value we used is 60 minutes.
  • Entries Threshold: The least amount
...