Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes


Accepted answer

Permanent link

 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.

Gil Br selected this answer as the correct answer

0 votes

Comments

It's genius! Thanks a lot !!!


One tiny issue to notice that the number is greater by one from the number of statuses, so I simply subtracted 1 off the formula:
Count($Work Item Status History:Work Item State History ID$) -1

Many thanks again!

 Yes - I noticed that too. It counts the (does not exist) -> Open as a state transition, so glad you caught that :)

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 1,221
× 360

Question asked: Nov 24 '19, 8:11 a.m.

Question was seen: 929 times

Last updated: Nov 26 '19, 10:46 a.m.

Confirmation Cancel Confirm