Project

General

Profile

How to make a project issue histogram?

Added by Ben Martinek over 13 years ago

Hi All,

I have been modifying the Whining plugin to send a email about the current state of a project. Nice pretty Google charts to give a a current breakdown of a project (management loves that kinda stuff). I have run into an issue though...

I want to make a histogram of a project for all the bugs opened and closed per day of a project.

I have looked in to the Issue history, but this seems a terribly inefficient way to do this. Seeing as I would have to Itterate through each day of each project I am tracking. and then find the status update.

Is there a better interface to do something like this I am missing? One though would be to make a new table in the DB to track this, but is seems like a pretty invasive action for a plugin.

Would love some advice.

Thanks in advance!


Replies (1)

RE: How to make a project issue histogram? - Added by Felix Schäfer over 13 years ago

Ben Martinek wrote:

I have looked in to the Issue history, but this seems a terribly inefficient way to do this. Seeing as I would have to Itterate through each day of each project I am tracking. and then find the status update.

I think the only way currently to find how many issues where closed is to find all IssueJournal containing a state change from an open to a closed state and find the corresponding issues, removing duplicates and looking if the issues are still closed or have been reopened since.

    (1-1/1)