Running Reports on User Activities for Specific Time Periods
Users are interested in running reports on user activities for specific time periods. ArMK would like to run reports for custom date ranges, such as 3-month periods. However, the current reporting feature only shows data accumulated over all time. Mittineague suggests that custom queries can be written to achieve this, but notes that it’s not realistic to have all possible queries as stock reports. ArMK is not familiar with writing custom queries and will resort to using a plugin for now. Jim.Morrison also expresses interest in this feature, specifically for day-by-day reporting on specific users.
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)
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
