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'

Selecting the Quarter results in custom way

Support

Stephen (Stephen) August 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 Likes

Topic		Replies	Views
Topic Count Per User for Custom Date? Support	1	793	August 4, 2020
Data Explorer Tutorial - Part 1 - Writing Your First Query Data & reporting data-explorer , sql-tutorial	0	1270	September 5, 2023
Discourse Data Explorer Plugin official , data-explorer	23	77845	April 16, 2025
Query Topics with Category Expert posts? Data & reporting data-explorer , category-experts	3	32	May 22, 2025
Dashboard Report - Topic View Stats Data & reporting sql-query , dashboard-reports , dashboard-sql	0	59	January 28, 2025

Selecting the Quarter results in custom way

Related topics