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 re…

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…

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	989	January 27, 2022
Export list of users based on date range Product Support	2	849	June 16, 2021
Complex user activity report requirement Data & reporting sql-query	22	2245	August 5, 2021
Adjusting date range for user stats Feature	4	974	February 1, 2018
Inconsistent stats from the "User Participation Statistics" query Data & reporting sql-query	10	826	November 16, 2022

Running Reports on User Activities for Specific Time Periods

Related topics