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…

[imagen] 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_p…

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…

Informe del panel - Sentimiento general - nº 2 por JammyDodger - Datos e informes

Tema		Respuestas	Vistas	Actividad
AI sentiment and emotion analysis reports Data & reporting sql-query , ai , ai-sentiment	0	149	15 Julio 2025
Dashboard Report - Post Emotion Data & reporting dashboard-reports , sql-query , dashboard-sql , ai-sentiment , ai	0	480	16 Febrero 2024
Add Sentiment score per topic Feature ai , ai-sentiment	1	172	23 Junio 2023
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1157	13 Noviembre 2024
Discourse AI - Sentiment Site Management ai , content , ai-sentiment , how-to	14	5602	24 Octubre 2025

AI sentiment and emotion analysis reports

Data & reporting

sql-query , ai , ai-sentiment

0

149

15 Julio 2025

Dashboard Report - Post Emotion

Data & reporting

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

0

480

16 Febrero 2024

Add Sentiment score per topic

Feature

ai , ai-sentiment

1

172

23 Junio 2023

Community Sentiment and Toxicity queries

Data & reporting

ai , sql-query

14

1157

13 Noviembre 2024

Discourse AI - Sentiment

Site Management

ai , content , ai-sentiment , how-to

14

5602

24 Octubre 2025

Informe del panel - Sentimiento general

Temas relacionados