[画像] User posts by email domain over last 7 days Data & reporting I think it actually gives inflated numbers due to the group joins (also, everyone is part of an automatic group for their trust level, so there’s a bit of inconsistency there). I think we can str…

I think having the results per user rather than grouped by email domain makes this a slightly different query. Let’s split this off into its own topic. :+1:

I think something like this should do it: -- [params] -- string :interval = 7 days WITH post_data AS ( SELECT p.user_id, COUNT(p.id) AS total_posts, COUNT(p.id) FILTER (WHERE p.post_number = 1 AND t.archetype = 'regular') AS topics, COUNT(p.id) FILTER (WHERE p.…

This is perfect!! Thank you so very much.

ユーザー統計とメール

コミュニティデータとレポート

Heather13 (Heather D) 2024 年 7 月 24 日午前 10:55 4

完璧です!!本当にありがとうございます。

トピック		返信	表示
User posts by email domain over last 7 days Data & reporting sql-query	3	343	2024 年 4 月 19 日
User participation Data & reporting sql-query	0	220	2017 年 11 月 17 日
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	228	2019 年 12 月 31 日
Posts Read (Daily) Data & reporting sql-query	0	155	2016 年 5 月 1 日
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	2024 年 11 月 25 日

ユーザー統計とメール

関連トピック