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. [image] southpaw: Kudo & Win shows 17 participants in the …

Data Explorer query help: metrics to understand unique individual participants

Données et rapports

sam (Sam Saffron) A scindé ce sujet () Décembre 13, 2017, 3:47 15

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

Sujet		Réponses	Vues
Unique list of topic participants? Support	3	31	Novembre 3, 2024
Top X posters in a given timeframe Data & reporting sql-query	3	139	Mai 28, 2024
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	22	5479	Novembre 12, 2021
How many users have posted at least one topic? Feature	1	735	Janvier 5, 2017
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	135	Décembre 31, 2019

Data Explorer query help: metrics to understand unique individual participants

Sujets connexes