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 been requested at Category level. I have looked in the classification_results table to understand how to join this, however there’s limited columns and just one called target_id but no idea what that refers to and I only see it in ai related tables Please support

[תמונה] 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 table based on the type.

[תמונה] 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 format that allows it to be expanded to other entities in the future. My data set is limited though, so if you could run this query and see what different types you have that would be very useful: SELECT target_type FROM classification_results GROUP BY 1

[תמונה] 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 analysis in this case would be applied 10 times, once to each post of a topic? Meaning if the ask was to create a dashboard which shows the sentiment score per topic by category, another step would be to then understand how many of the posts of a topic even have had sentiment analysis applied, then create an average?

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 specific ones for that model. [תמונה] SStrong: Meaning if the ask was to create a dashboard which shows the sentiment score per topic by category, another step would be to then understand how many of the posts of a topic even have had sentiment analysis applied, then create an average? I think this may depend on which results you’re interested in. The positive/negative sentiments may lend themselves better to that concept. The emotion ones might be better laid out as separate columns per topic. But you may be able to get some ideas from the existing ones: [תמונה] Dashboard Report - Overall Sentiment Data & reporting 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 period. By leveraging sentiment analysis, the report categorizes posts as either positive or negative based on a defined threshold, which can be adjusted. This categorization is then used to calcula… [תמונה] Dashboard Report - Post Emotion Data & reporting This is an SQL version of the Dashboard Report for Post Emotion. discourse This report requires the Discourse AI plugin and Sentiment Analysis to be enabled. This dashboard report shows the number of posts classified with one of following emotions, group by poster trust level, within a specified date range: Sadness Surprise Fear Anger Joy Disgust Admiration Amusement Annoyance Approval Caring Confusion Curiosity Desire Disappointment Disapproval Embarrassment Excitement Gratitude Grief L…

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

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?

בקשת תמיכה לחיבור classification_results table לטבלאות אחרות

קהילה נתונים ודיווח

SStrong (Sophie Strong) 3 ביולי,‏ 2025,‏ 9:28am 7

קוד ניתוח הסנטימנט הכללי אינו פועל, איני מקבל כלל תוצאות אך ניתוח הסנטימנט בצד הלקוח מציג עבור משתמשים

נושא		תגובות	צפיות
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1570	13 בנובמבר,‏ 2024
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	1145	15 בדצמבר,‏ 2023
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	985	3 ביולי,‏ 2025
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	601	16 בפברואר,‏ 2024
Classification in the Discourse Sentiment Dashboard Product Support ai , ai-sentiment	8	537	25 ביוני,‏ 2026

בקשת תמיכה לחיבור classification_results table לטבלאות אחרות

נושאים קשורים