Admin can currently run report on user activity and download as CSV file… extremely useful for compiling and analyzing data. However, the current reports show data accumulated over all time. I’m wondering if there is a way to run reports for specific periods of time. For example, I want to run a report on user activities for a 3-month period like January 1, 2017 to March 31, 2017. Is this currently possible? (Note: I didn’t want to unnecessarily bump this topic, please feel free to merge if appropriate)

As was answered in that topic https://meta.discourse.org/t/reports-on-user-activity/26525/10?u=mittineague Many tables have datetime fields. By writing a query that does JOINs, sub SELECTs etc. on the tables of interest the query can use GROUP BY to get all kinds of result sets. Because there are so many possible queries that could be run it’s not realistic to attempt having all of them as Reports. But I imagine if enough people want something that is not a stock Report there is a chance it could become one. AFAIK, there are plans to allow better exposure of results from custom queries, but it’s still a ways into the future.

Thanks @Mittineague. I was wondering about a native way to do this. Maybe enough people ask for the same thing. For now, I will resort to the plug-in for the time being. I’m just not too familiar with the coding part writing out the queries :slight_smile:

Running Reports on User Activities for Specific Time Periods

Product Support

Jim.Morrison (Jim Morrison) October 1, 2019, 11:13pm 4

bumping for Interest in the same type of reporting feature on specific users for a day by day basis.

Topic		Replies	Views
Custom time period in Dashboard Data & reporting	7	1007	January 27, 2022
Export list of users based on date range Product Support	2	866	June 16, 2021
Complex user activity report requirement Data & reporting sql-query	22	2334	August 5, 2021
Adjusting date range for user stats Feature	4	983	February 1, 2018
Inconsistent stats from the "User Participation Statistics" query Data & reporting sql-query	10	866	November 16, 2022

Running Reports on User Activities for Specific Time Periods

Related topics