JRS - Count number of states work-items did on average
Hi,
I like to generate a report of the number of states on average workitems of a specific type made over time.
For example we have 14 states in a flow of a bug, from open to close we have few paths, I like to get the number of how many states on average are used to get from open to close (a state can be visited more than once)
Any ideas?
Gil
Accepted answer
If you're using a data warehouse based report, you can get creative with the 'Work Item Status History' to do something like this.
Use traceability to link from 'Work Item Status History' to its related 'Work Item'
Then in the Format Results area, you can use a custom expression to count the number of 'Work Item Status History' entries for each work item.
From here you should be able to play around to get at least close to what you want.
Comments
