Test DB
Daily User Count

Last run: 2025-05-17 00:00:00 • Next run: 2025-05-24 08:00:00 • Schedule: 0 8 * * *

SQL Query

SELECT COUNT(*)
FROM users
WHERE DATE(date_joined) =
CURRENT_DATE - INTERVAL '1 day';

Anomalous value detected (6.04 standard deviations from mean)

Current Value

208

Expected Range

304.66 - 343.00

Z-Score

-6.04

Avg Value

314.92

Success Rate

100%

Alert Rate

Avg Response

54 ms

Ran At	Fields	Alert Type	Duration
2025-05-17 00:00	count=208	Anomaly	54 ms
2025-05-16 00:00	count=337	OK	55 ms
2025-05-15 00:00	count=320	OK	58 ms
2025-05-14 00:00	count=293	OK	51 ms
2025-05-13 00:00	count=349	OK	52 ms
2025-05-12 00:00	count=346	OK	59 ms
2025-05-11 00:00	count=308	OK	51 ms
2025-05-10 00:00	count=300	OK	56 ms
2025-05-09 00:00	count=337	OK	54 ms
2025-05-08 00:00	count=302	OK	57 ms
2025-05-07 00:00	count=313	OK	53 ms
2025-05-06 00:00	count=339	OK	56 ms
2025-05-05 00:00	count=342	OK	58 ms