Project

General

Profile

Forums » Open discussion »

Question: analysing project bottlenecks

Added by Igor R almost 11 years ago

Hello,

We've got the following use-case:

1) An issues is being assigned to a project member A.
2) The member A works some time on this issue, then re-assigns it to a member B.
3) Member B works some time on this issue, then re-assigns it back to a member A, etc.

We'd like to generate the following reports:

1) For every issue, for a specified period, to see how long the issue was assigned to every member. Like this:
"Issue I1: user A 3 days (30% of the issue lifetime); user B 7 days (70% of the issue lifetime)", etc.
2) For every project member, for a specified period, to see the list of issues assigned to him. Like this:
"User A: issue I1, InProgress, [1-jan..3-jan]; issue I2, Assigned, [2-jan..3-jan]; issue I1, InProgress, [3-jan..5-jan]", etc.

The report may be graphical or textual, it doesn't matter much.
Is the above possible with the current Redmine feature-set or with one of the existing plugins?


Replies (2)

RE: Question: analysing project bottlenecks - Added by Jan Niggemann (redmine.org team member) almost 11 years ago

I can't come up with a solution right now, but from the top of my head I'd say that this is at least possible using SQL, the relevant tables contain all the data you need...

RE: Question: analysing project bottlenecks - Added by Igor R almost 11 years ago

Thanks for you response.
What would be more simple (taking into account that I'm unfamiliar with RoR): to accomplish this as a plugin or to make a stand-alone report/application based directly on the Redmine Database?

    (1-2/2)