Why does this ‘Overall Sentiment’ query gives empty results: [image]

I copied directly from Sara’s post and ran it and received results: [image] Can you confirm if you have data in your classification_results table?

[image] Jordan Violet: I copied directly from Sara’s post and ran it I also just copied, pasted it as a ‘New Query’ and ran. No changes by me made at all. [image] Jordan Violet: Can you confirm if you have data in your classification_results table? From where do I need to look for this? I’m admin of my site. My dashboards looks like this: [image] [image]

[image] Bathinda Helper: No changes by me made at all. Did you change the dates that the query covered? Try refreshing the page and amending the date parameters if you haven’t already done so.

I’ve tried entering longer duration (and then 'Refresh) in the dashboard with no success: [image] And also changed dates in the query, with no success: [image] My site is approx/minimum 5 years old.

[image] Bathinda Helper: My site is approx/minimum 5 years old. Did you run a backfill? [image]Discourse AI - Sentiment :information_source: Once enabled, Sentiment will classify all new posts going forward. To classify all of your site’s historical posts, a backfill task must be run from the console

[image] Moin: Did you run a backfill? No. I didn’t. Nor did I read about this in (the first post of) this topic. Can u pls tell how do/can I do that? Or if I don’t run backfill, when will this component get enough posts to work out the sentiment?

That’s explained in the guide I quoted. When did you enable the sentiment analysis? You chose February 2024 as an end date in your data explorer query. Was the analysis enabled before that? Otherwise, since only new posts are classified, I’d expect it to return 0 results.

[image] Moin: That’s explained in the guide I quoted. Ok, I had missed, but now I’d surely study and solve the problem. Analysis was enabled in Feb or March, 2024, I don’t remember exact date. How many posts does it require (after its enabled, without running back-fill) to show something?

[image]Discourse AI - Sentiment Once enabled, Sentiment will classify all new posts going forward. To classify all of your site’s historical posts, a backfill task must be run from the console. I’m seeing ‘Site Sentiment’ in my Admin Dashboard for the past 2-3 months, but no sentiment is being shown. [image] I even tried running the same as an Sql Query thru Data Explorer plugin and changed dates to approx 2 years, still only blank result. [image] When I try run a ‘BackFill Task’ it gave the following error: [image] I took screenshot of almost 50% of the top area. As shown in the ‘just-above’ post of mine that Back-Filling is failing, can someone pls tell how many days/how many posts will it take for this ‘Sentiment Analysis’ to work or show something (i.e. wo backfill)? I’ve searched ‘Back-Fill-Failing’ on meta, but no solution has been found anywhere.

I’ve collected these up and split them into their own topic so they’re not cross-posted in multiple places. :+1:

Problems setting up Sentiment

Product Support

jordan-violet (Jordan Violet) May 23, 2024, 3:51am 2

I copied directly from Sara’s post and ran it and received results:

Can you confirm if you have data in your classification_results table?

Topic		Replies	Views
Adding a backfill to Sentiment Analysis Feature completed , ai , ai-sentiment	3	475	November 11, 2023
Discourse AI - Sentiment Site Management how-to , ai , ai-sentiment , content	12	6426	October 24, 2025
Classification in the Discourse Sentiment Dashboard Product Support ai , ai-sentiment	8	535	June 25, 2026
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	981	July 3, 2025
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1564	November 13, 2024

Problems setting up Sentiment

Related topics