Hi, We are using Discourse for our community platform and we have a bit different Quarterly system required for our team reporting which is sent out to the Staff members. [image] Currently, the Quarterly shows the month from May 30th till August 30th. But, we want to see the result from May 1st…

Your query would only return topics if they were created at exactly midnight on that date. If you’re looking for topics created any time on that day, you would use something like this: SELECT * FROM topics WHERE created_at >= '2022-05-01' AND created_at < '2022-05-02'

以自定义方式选择季度

支持

Stephen (Stephen) 2022 年8 月 30 日 17:47 3

The date ranges in your screenshot are based on the current date. You can use Data Explorer to pull out more tailored views.

3 个赞

话题		回复	浏览量
Topic Count Per User for Custom Date? Support	1	808	2020 年8 月 4 日
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	12906	2025 年5 月 6 日
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1521	2019 年3 月 29 日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	24	79217	2025 年7 月 16 日
Custom time period in Dashboard Data & reporting	7	801	2022 年1 月 27 日

以自定义方式选择季度

相关话题