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 till July 30th. Please tell us how it can be possible from the UI OR if there is a way to use some sort of Plugin which can query the database directly. Thanks

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'

The date ranges in your screenshot are based on the current date. You can use Data Explorer to pull out more tailored views. [image] Discourse Data Explorer Plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #data-reporting category under the #sql-query tag. If there’s not one to suit your par…

Thanks for the reply. We do have this plugin and I was for e.g. able to get a simple select query for that particular table. e.g. SELECT * FROM topics LIMIT 1 Link to CSV file However, if I modify the same query to get the results from Month of May, I get no result i,e. SELECT * FROM topics WHERE created_at='2022-05-01' LIMIT 5 Can you please help. Thanks

Thank you. That gives me the results I wanted :slight_smile:

Selecting the Quarter results in custom way

Product Support

usman (usman) September 1, 2022, 11:44am 6

Thank you. That gives me the results I wanted

Topic		Replies	Views
Topic Count Per User for Custom Date? Product Support	1	899	August 4, 2020
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14436	May 6, 2025
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1678	March 29, 2019
Custom time period in Dashboard Data & reporting	7	1009	January 27, 2022
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	87658	October 22, 2025

Selecting the Quarter results in custom way

Related topics