Data Explorer query help: metrics to understand unique individual participants

david · 20 Ottobre 2017, 4:45pm

Unfortunately the only documentation is the code itself. I’m pretty sure participant_count should be the number of unique posters…

github.com/discourse/discourse

db/migrate/20131114185225_add_participant_count_to_topics.rb

cf9607a0c


      
          class AddParticipantCountToTopics < ActiveRecord::Migration[4.2]
            def up
              add_column :topics, :participant_count, :integer, default: 1
          
              execute "UPDATE topics SET participant_count =
                        (SELECT COUNT(DISTINCT p.user_id) FROM posts AS p WHERE p.topic_id = topics.id)"
            end
          
            def down
              remove_column :topics, :participant_count
            end
          
          end

Do you have an example public topic where it doesn’t match up?

Argomento		Risposte	Visualizzazioni
Unique list of topic participants? Support	2	143	Ottobre 4, 2024
Top X posters in a given timeframe Data & reporting sql-query	3	271	Maggio 28, 2024
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	20	5780	Dicembre 20, 2018
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	211	Luglio 23, 2026
How many users have posted at least one topic? Feature	1	786	Gennaio 5, 2017

Data Explorer query help: metrics to understand unique individual participants

Argomenti correlati