Hey there Data Explorer wizards! Has anyone ever tried creating a query that will give the count for total participation moments by moth using Data Explorer queries? I mean total number of all posts, solutions, likes by month. Thanks in advance!

Hi Konrad, Below is the adjusted query. WITH monthly_users AS ( SELECT date_part('year', created_at) AS year, date_part('month', created_at) AS month, COUNT(*) AS "new_users_month" FROM users WHERE id > 0 GROUP BY date_part('year', created_at), date_part(…

Look if you like this. querys.md queries --- This plugin allows admins to run SQL queries against the live Discourse database, including parameterized queries and formatting for several common column types. More info: https://meta.discourse.org/t/data-explorer-plugin/32566 ---…

I don’t see the exact one I’m looking for

[图片] Konrad_Sopala: Hey there Data Explorer wizards! I’m not a Data Explorer expert, but I like writing queries when I’ve got time. Before I get too carried away with this, I’m assuming you’re looking for a month by month breakdown of the stats. If so, something like this might work: --[para…

Thanks @simon for sharing that that is really helpful and it’s mostly what I’m looking for! Can I ask you if it’s possible to make one change to the query? I don’t like to specify the start date. I would like to sum up all those values (posts, users, solutions, likes) and have the query result like…

[图片] Konrad_Sopala: I don’t like to specify the start date. I would like to sum up all those values (posts, users, solutions, likes) and have the query result like that, by month: This might be possible. I’ll give it a try. The start date parameter was added to the query at the last minute wh…

Sure! Waiting then for you once you have time to make that adjustment

That’s exactly what I was looking for! Thanks again @michebs ! Have you folks thought about creating some sort of open-source collection of Data Explorer queries and sharing it with Discourse users?

Yes, that’s the built in list of queries that are included with Data Explorer :wink:

yep I know but is it something that you expand? for example based on the questions here from the forum

We can accept PRs to add queries, here’s an example: FEATURE: Add a poll results query master ← poll-results merged 01:21AM - 23 Nov 19 UTC (UTC) [图片] …

使用 Data Explorer 按月计算总参与次数

社区数据与报告

rishabh 2021 年2 月 25 日 07:38 14

我们可以接受添加查询的 PR，示例如下：

此外，(Superseded) What cool data explorer queries have you come up with? 以及 @SidV 的列表 discourse-data-explorer/querys.md at queries · SidVal/discourse-data-explorer · GitHub 也提供了大量有用的查询！

话题		回复	浏览量
Retrospectively pulling number of users each calendar month Data & reporting	9	237	2024 年11 月 12 日
Help finding some monthly site stats about topics and user trust levels Data & reporting sql-query	22	5568	2021 年11 月 12 日
Get member count overall by month using Data Explorer Data & reporting sql-query	6	646	2021 年3 月 12 日
Data Explorer averages by year? Data & reporting sql-query	6	1376	2020 年5 月 17 日
Aggregate dashboard report data by time interval Data & reporting sql-query	4	1165	2022 年9 月 24 日

使用 Data Explorer 按月计算总参与次数

相关话题