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_post…

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…

대시보드 보고서 - 전반적인 감정 분석 - JammyDodger 님의 게시물 #2 - 데이터 및 보고

글		댓글	조회수	활동
AI sentiment and emotion analysis reports Data & reporting ai , sql-query , ai-sentiment	0	302	7월 15, 2025
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	585	2월 16, 2024
Add Sentiment score per topic Feature ai , ai-sentiment	1	233	6월 23, 2023
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1487	11월 13, 2024
Discourse AI - Sentiment Site Management how-to , ai , ai-sentiment , content	12	6272	10월 24, 2025

AI sentiment and emotion analysis reports

Data & reporting

ai , sql-query , ai-sentiment

0

302

7월 15, 2025

Dashboard Report - Post Emotion

Data & reporting

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

0

585

2월 16, 2024

Add Sentiment score per topic

Feature

ai , ai-sentiment

1

233

6월 23, 2023

Community Sentiment and Toxicity queries

Data & reporting

ai , sql-query

14

1487

11월 13, 2024

Discourse AI - Sentiment

Site Management

how-to , ai , ai-sentiment , content

12

6272

10월 24, 2025

대시보드 보고서 - 전반적인 감정 분석

Related topics