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 日 03: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

相关话题