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

[이미지] 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 ana…

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 6월 25, 2025, 4:33오후 2

이것은 target_type 열에 따라 달라지는 것 같습니다. 예를 들어, target_type이 'post’인 경우 target_id는 post_id가 됩니다.

글		댓글	조회수
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1324	11월 13, 2024
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	965	12월 15, 2023
Dashboard Report - Overall Sentiment Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	2	884	7월 3, 2025
Dashboard Report - Post Emotion Data & reporting ai , sql-query , dashboard-reports , ai-sentiment , dashboard-sql	0	554	2월 16, 2024
Classification in the Discourse Sentiment Dashboard Support ai , ai-sentiment	8	315	6월 25, 2026

classification_results 테이블을 다른 테이블과 조인하는 방법에 대한 지원 요청

Related topics