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).

AI 分诊自动化报告的垃圾邮件标记统计

社区数据与报告

Jagster (Jakke Flemming) 2025 年5 月 31 日 06:18 2

我得到了

PG::DivisionByZero: ERROR:  division by zero

话题		回复	浏览量
Analyzing Moderation and Flagging Activity Reports Data & reporting moderation , sql-query	0	312	2025 年2 月 13 日
Discourse AI - Spam detection Site Management moderation , how-to , ai , spam	31	5918	2026 年8 月 28 日
Dashboard Report - Flags Status Data & reporting sql-query , dashboard-reports , dashboard-sql	0	457	2023 年12 月 22 日
Dashboard Report - User Flagging Ratio Data & reporting sql-query , dashboard-reports , dashboard-sql	0	403	2024 年2 月 6 日
Posts and account not always restored when flag from Discourse AI spam detection rejected Bug ai , spam	10	634	2025 年2 月 13 日

AI 分诊自动化报告的垃圾邮件标记统计

相关话题