Give me the 3 most disruptive flaky tests for the last month.
Agent
⏺develocity analytics · execute_query
SELECT work_unit_path,
COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END) AS builds_affected,
ROUND(100.0 * COUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END)
/ COUNT(DISTINCT build_id), 2) AS fail_rate_pct
FROM test_performance_summary
WHERE build_start_date >= DATE '2026-05-12' AND work_unit_path IS NOT NULLGROUP BY work_unit_path
HAVINGCOUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count > 0 THEN build_id END) > 0
ANDCOUNT(DISTINCT CASE WHEN work_unit_failed_test_classes_count = 0 THEN build_id END) > 0
ORDER BY builds_affected DESCLIMIT 3;
└ 3 rows
The 3 test tasks that failed the most builds while also passing in others — classic flaky behavior: