When I look at an individual topic, I can unfold a list of individuals who have posted on the topic, and the number of times they have done so: [image] Could someone please help me build a query in Data Explorer to determine: Average number of unique individuals per topic (day/week/month/year) T…

discourse/discourse/blob/main/app/models/topic_featured_users.rb#L87-L88 private While calculating participant_count we are ignoring hidden post users. [画像] southpaw: Kudo & Win shows 17 participants in the que…

Data Explorer query help: metrics to understand unique individual participants

データとレポート

sam (Sam Saffron) このトピックを分割しました: 2017 年 12 月 13 日午前 3:47 15

A post was split to a new topic: 24 user max in topic statistics

トピック		返信	表示
Unique list of topic participants? Support	3	31	2024 年 11 月 3 日
Top X posters in a given timeframe Data & reporting sql-query	3	139	2024 年 5 月 28 日
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	22	5479	2021 年 11 月 12 日
How many users have posted at least one topic? Feature	1	734	2017 年 1 月 5 日
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	135	2019 年 12 月 31 日

Data Explorer query help: metrics to understand unique individual participants

関連トピック