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

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 Разделил(а) эту тему 24.Май.2024 09:28:47 2

9 posts were split to a new topic: Problems with Sentiment Backfill

Тема		Ответов	Просм.
AI sentiment and emotion analysis reports Data & reporting sql-query , ai , ai-sentiment	0	128	15.07.2025
Dashboard Report - Post Emotion Data & reporting dashboard-reports , sql-query , dashboard-sql , ai-sentiment , ai	0	469	16.02.2024
Add Sentiment score per topic Feature ai , ai-sentiment	1	162	23.06.2023
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1116	13.11.2024
Discourse AI - Sentiment Site Management ai , content , ai-sentiment , how-to	14	5522	24.10.2025

Отчет по панели управления: общий тон

Связанные темы