[이미지] 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 st…

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.

사용자 통계 및 이메일

커뮤니티 구축 데이터 및 보고

JammyDodger 7월 23, 2024, 9:48오전 2

결과를 이메일 도메인으로 그룹화하는 대신 사용자별로 표시하는 것이므로, 이 쿼리는 약간 다른 성격이라고 생각합니다. 이 부분은 별도의 주제로 분리해 보겠습니다.

글		댓글	조회수
User posts by email domain over last 7 days Data & reporting sql-query	3	343	4월 19, 2024
User participation Data & reporting sql-query	0	220	11월 17, 2017
Daily, weekly, or total stats by user over a specified time range Data & reporting sql-query	0	228	12월 31, 2019
Posts Read (Daily) Data & reporting sql-query	0	155	5월 1, 2016
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	11월 25, 2024

사용자 통계 및 이메일

Related topics