How to get a report showing number of open/closed issues rather than time spent?
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.