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…

app/models/topic_featured_users.rb main private While calculating participant_count we are ignoring hidden post users. [תמונה] southpaw: Kudo & Win shows 17 participants in the query results, but when I un…

I thought this would be really complicated, but turns out there’s a handy “participant_count” column in the database :slight_smile: Top topics by number of unique participants over the last year -- [params] -- string :interval = 1 year SELECT id as topic_id, participant_count FROM topics WHERE b…

Thank you so much @david ! That’s a tremendous help! (And thank you @zogstrip for moving the thread to the right category. I’ll get my bearings eventually.)

Is there documentation anywhere of what the different variables, like participant_count actually represent? The top topics query is returning numbers that don’t match the “Frequent posters” image in the thread. I’m wondering if it includes likes or some other activity.

Unfortunately the only documentation is the code itself. I’m pretty sure participant_count should be the number of unique posters… db/migrate/20131114185225_add_participant_count_to_topics.rb cf9607a0c class AddParticipantCountToTopics < ActiveRecord::Migration…

[תמונה] david: Do you have an example public topic where it doesn’t match up? Thanks for following up. I want to explore it further, and will post some examples if I can’t sort things out on my own.

Hi @david , Sorry for the very long delay. I do have some examples now. Sometimes the query is right, sometimes the count displayed in the thread is right. Sometimes they report the same number and are both right! I noticed that when the counts differ, the threads have had posts split off to new th…

[תמונה] southpaw: when the counts differ, the threads have had posts split off to new threads. I believe this is mostly expected. Important to note.

[תמונה] southpaw: I noticed that when the counts differ, the threads have had posts split off to new threads. I tested this functionality. I am unable to reproduce it. As I described in previous post the counts are differ (for staffs) only if the topic had deleted posts. [תמונה] southpaw: …

Data Explorer query help: metrics to understand unique individual participants

קהילה נתונים ודיווח

נושא		תגובות	צפיות
Unique list of topic participants? Support	3	62	3 בנובמבר,‏ 2024
Top X posters in a given timeframe Data & reporting sql-query	3	187	28 במאי,‏ 2024
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	22	5575	12 בנובמבר,‏ 2021
How many users have posted at least one topic? Feature	1	747	5 בינואר,‏ 2017
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	169	31 בדצמבר,‏ 2019

Data Explorer query help: metrics to understand unique individual participants

נושאים קשורים