This SQL query provides statistics about spam flags reported by the Discourse AI - AI triage automation. It calculates the total number of flags, how many were approved or rejected, and the corresponding percentages. This report is useful for understanding how effective automated spam detection is o…

And I got PG::DivisionByZero: ERROR: division by zero

That error happens because there were no spam flags by @system that you agreed or disagreed with during that time span. The query tries to divide by the total number of flags that meet the conditions. In your case that is 0, so it breaks. If you want the query to still return a result, you can use…

I’ve got a few, all false positives, but I can’t remember how I handled those. But something like that I guessed too (I’m really bad at reading SQL).

Statistiken zu Spam-Markierungen, die von der KI-Triage-Automatisierung gemeldet wurden

Gemeinschaft Daten & Berichterstattung

Jagster (Jakke Flemming) 31. Mai 2025 um 10:48 4

Ich habe ein paar, allesamt falsche Positive, aber ich kann mich nicht mehr erinnern, wie ich damit umgegangen bin.

Aber so etwas habe ich auch vermutet (ich bin wirklich schlecht im Lesen von SQL).

Thema		Antworten	Aufrufe
Analyzing Moderation and Flagging Activity Reports Data & reporting moderation , sql-query	0	313	13. Februar 2025
Discourse AI - Spam detection Site Management moderation , how-to , ai , spam	31	5937	28. August 2026
Dashboard Report - Flags Status Data & reporting sql-query , dashboard-reports , dashboard-sql	0	457	22. Dezember 2023
Dashboard Report - User Flagging Ratio Data & reporting sql-query , dashboard-reports , dashboard-sql	0	403	6. Februar 2024
Posts and account not always restored when flag from Discourse AI spam detection rejected Bug ai , spam	10	641	13. Februar 2025

Statistiken zu Spam-Markierungen, die von der KI-Triage-Automatisierung gemeldet wurden

Verwandte Themen