I have a request to create using data explorer dashboards at Category level with certain key metrics that will be automated via automation every month, going to Category moderators so that they can be aware of performance, make business decisions off the back of it. Sentiment analysis - this has be…

[image] SStrong: one called target_id but no idea what that refers to I think this is dependant on the target_type column. For instance, if it’s got a target_type of ‘post’ then the target_id is a post_id

Thanks, that helps a lot. So just to check—if target_type is ‘post’, then I should join classification_results.target_id to posts.id, right? And if the target_type is something else, like ‘comment’, then I’d join it to the comments table instead? Just want to make sure I’m joining to the right tab…

[image] Michael12: And if the target_type is something else, like ‘comment’, then I’d join it to the comments table instead? I’m not sure comments are processed by AI sentiment. :thinking: Is this a target_type you’re seeing in your data? I think it may currently be post only, but with a for…

[image] JammyDodger: SELECT target_type FROM classification_results GROUP BY 1 I can only see post as a target_type. Am I correct in thinking that a post is a multiple of types in it’s on right as well. For example, one topic can have 10 posts in total. So does that mean that the sentiment a…

The sentiment analysis is applied at the post level, so each post would have its own record in the classification_results table. Each post would also have a separate record for every model applied to it as well, so depending on which results you’re interested in you’d want to filter out those specif…

Hmm. :thinking: I’ve just given it a test and it works for me. Maybe a little basic, but just to check, did you adjust the date range parameters to something more recent than the default ones?

Joining classification_results table to other tables support request

Community Building Data & reporting

SStrong (Sophie Strong) July 3, 2025, 9:28am 7

Overall sentiment code is not working, I get no results at all but the fronn=t end sentiment analysis is showing for users

Topic		Replies	Views
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1515	November 13, 2024
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	1111	December 15, 2023
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	951	July 3, 2025
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	591	February 16, 2024
Classification in the Discourse Sentiment Dashboard Product Support ai , ai-sentiment	8	484	June 25, 2026

Joining classification_results table to other tables support request

Related topics