Discourse 리액션

[Lilly (Lillian)]

참고로 포럼의 admin dashboard - reports에 대시보드 보고서가 있습니다:

데이터 탐색기(Data Explorer) 버전으로 작업할 수도 있습니다.

대시보드 보고서 - 반응

This is an SQL version of the Dashboard Report for Reactions. This report provides a daily count of all likes and reactions to posts across a site over a specified date range. This report helps provide a snapshot of user engagement within a Discourse community by measuring the frequency of various reaction emojis and likes on posts. By analyzing the usage of different reaction emojis, administrators can gain insights into how often users interact with content, users’ emotional responses to pos…

#data-reporting 카테고리를 검색해 보면 작업할 아이디어를 찾거나 시작하는 데 도움이 될 수 있습니다.

이모지 사용

I’m planning to replace retort with discourse reactions. To find out which emojis to use, I wanted to know how their usage in my forum is. As I couldn’t find a query for this I share mine: Count emojis added with the retort plugin SELECT count(*), REGEXP_MATCHES(key, '([a-z_+]+)|retort') emoji FROM post_details WHERE extra = 'retort' GROUP BY key ORDER BY 1 DESC Count emojis in posts (without the system user) SELECT count(*), REGEXP_MATCHES(raw, ' :([a-z_]+): ', 'g') emoji …