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 ai , sql-query , ai-sentiment	0	276	2025年七月15日
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	570	2024年二月16日
Add Sentiment score per topic Feature ai , ai-sentiment	1	222	2023年六月23日
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1377	2024年十一月13日
Discourse AI - Sentiment Site Management how-to , ai , ai-sentiment , content	12	6174	2025年十月24日

AI sentiment and emotion analysis reports

Data & reporting

ai , sql-query , ai-sentiment

0

276

2025年七月15日

Dashboard Report - Post Emotion

Data & reporting

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

0

570

2024年二月16日

Add Sentiment score per topic

Feature

ai , ai-sentiment

1

222

2023年六月23日

Community Sentiment and Toxicity queries

Data & reporting

ai , sql-query

14

1377

2024年十一月13日

Discourse AI - Sentiment

Site Management

how-to , ai , ai-sentiment , content

12

6174

2025年十月24日

仪表盘报告 - 整体情绪

相關主題