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…

[圖片] 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…

[圖片] 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…

[圖片] 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 anal…

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…

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 表与其他表连接

社区数据与报告

JammyDodger 2025年七月3日 18:48 8

嗯。我刚测试了一下，对我来说是有效的。

也许有点基础，但只是为了确认一下，你是否将日期范围参数调整到了比默认值更新的日期？

話題		回覆	觀看
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1391	2024年十一月13日
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	1019	2023年十二月15日
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	909	2025年七月3日
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	572	2024年二月16日
Classification in the Discourse Sentiment Dashboard Support ai , ai-sentiment	8	376	2026年六月25日

请求支持：将 classification_results 表与其他表连接

相關主題