This is an SQL version of the Dashboard Report for Overall Sentiment. :discourse: This report requires the Discourse AI plugin and Sentiment Analysis to be enabled. This dashboard report compares the number of posts classified either positive or negative with the “Sentiment” AI, over a specified…

[图片] SaraDev: -- [params] -- date :start_date = 2024-01-13 -- date :end_date = 2024-02-14 -- double :threshold = 0.60 SELECT DATE_TRUNC('day', p.created_at)::DATE AS date, COUNT(CASE WHEN (classification->>'positive')::float > :threshold THEN 1 ELSE NULL END) AS positive_sentiment_posts…

Hi Sophie, When did you enable the sentiment analysis on your site? If you chose February 2024 as an end date in this query, was the analysis enabled before that? With AI sentiment, only new posts are classified since the date that the analysis was enabled, so if you didn’t have it enabled before…

仪表盘报告 - 整体情绪 - #2，来自 JammyDodger - 数据与报告

话题		回复	浏览量	活动
AI sentiment and emotion analysis reports Data & reporting sql-query , ai , ai-sentiment	0	144	2025 年7 月 15 日
Dashboard Report - Post Emotion Data & reporting dashboard-reports , sql-query , dashboard-sql , ai-sentiment , ai	0	479	2024 年2 月 16 日
Add Sentiment score per topic Feature ai , ai-sentiment	1	172	2023 年6 月 23 日
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1155	2024 年11 月 13 日
Discourse AI - Sentiment Site Management ai , content , ai-sentiment , how-to	14	5572	2025 年10 月 24 日

AI sentiment and emotion analysis reports

Data & reporting

sql-query , ai , ai-sentiment

0

144

2025 年7 月 15 日

Dashboard Report - Post Emotion

Data & reporting

dashboard-reports , sql-query , dashboard-sql , ai-sentiment , ai

0

479

2024 年2 月 16 日

Add Sentiment score per topic

Feature

ai , ai-sentiment

1

172

2023 年6 月 23 日

Community Sentiment and Toxicity queries

Data & reporting

ai , sql-query

14

1155

2024 年11 月 13 日

Discourse AI - Sentiment

Site Management

ai , content , ai-sentiment , how-to

14

5572

2025 年10 月 24 日

仪表盘报告 - 整体情绪

相关话题