How to get a report showing number of open/closed issues rather than time spent?

Added by Simon B about 9 years ago

We have a team of staff opening and closing issues. Ideally we would like to analyse the number of issues opened and closed by each user on a daily/weekly/monthly basis e.g.

daily report:
user     opened closed 
bob      5       11
jeff     3       2
maria    10      1

weekly report
user     opened closed 
bob      55       111
jeff     33       22
maria    100      6

Has anyone already done this? This strikes me as a potentially common request from managers.
If there is no plugin available, i would equally be interested in the mysql query you would need to perform instead.
many thanks