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) 30 באוגוסט,‏ 2022,‏ 5:47pm 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	4 באוגוסט,‏ 2020
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	12911	6 במאי,‏ 2025
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1521	29 במרץ,‏ 2019
Discourse Data Explorer Plugin official , data-explorer , included-in-core	24	79240	16 ביולי,‏ 2025
Custom time period in Dashboard Data & reporting	7	801	27 בינואר,‏ 2022

בחירת הרבעון בדרך מותאמת אישית

נושאים קשורים