How can I report on the age of defects (in a particular state) in my workflow?
We have a defect workflow that has (among others) a "Accepted", a "In Progress" and a "Ready" state.
I need to know how to run a query to see how long defects have been in a specific state.
Histogram View:
My backlog (the accepted state) may have many very old items that are becoming stale. I need to know if this is happening so I'd like a histogram graph showing the number of defects vs. the age in state "Accepted".
Burndown View:
I would also like to know the average age of defects in the "Accepted" state - to make sure that my work-rate is high enough.
Work-rate per team member:
I would also like to know the workrate (defects moving from "Accepted" to "In Progress"; and "In Progress" to "Ready") per team member. I would also like to be able to get a histogram view as described above per team member for the "In Progress" state to make sure that no defects are getting neglected.
Regards,
Greg
One answer
If you are using CLM 5.0.2+ you can use JRS to build such report. If not, try the RRDI or BIRT reports. Unfortunately using simple queries you can't do that.
Comments
Any clues as to how to do it?
Which solution? Using JRS is pretty easy to explain, but the others are a bit complex...
In this answer are giving some tips:
https://jazz.net/forum/questions/199437/how-to-extract-workitem-state-change-historty-data-from-rtc