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

JRS Reporting to calculate state history for Work Item 7.0.2

Questions
Tags
Users
Badges
Chandan M B
(113●1●42●84) Feb 17 '23, 6:54 a.m.

 Hi,


 I saw some of the older posts suggesting to use workitem history to create such a reports. Nobody has commented they are successful in achieving that.

My use case is to calculate the calculating the number of workitem residing in the same state from how many days of the previous state. Similar way I need to do for all state in a single JRS report.

Any solution leads would be helpful

0 votes

Comments
David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Feb 17 '23, 8:12 a.m.
Is this for reporting against Data Warehouse or against Lifecycle Query Engine?

Chandan M B
Feb 17 '23, 8:27 a.m.
I am using Data warehouse 

1 answer
4,267 views
0 votes

One answer

Permanent link
David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (1.8k●1●7) edited
Feb 17 '23, 9:28 a.m.
Look at reports using the Work Item Status History. That records changes to a work item status, its previous state, how many days it has been in that state and so on. You might want to use a traceability path from work item to work item status history so that you can set conditions on the work item:

0 votes

Comments
Chandan M B
Feb 17 '23, 9:34 a.m.
Thanks. I was trying with historical trends to build a graph on number of workitems present in that state against number of days. Can you tell me when to use Historical Trends vs Current Data ?

David Honey
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Feb 17 '23, 9:55 a.m.
Historical trends is used when you want to spot trends over time. For example, have a graph of the number of closed versus open work items over some time period. In other words where the X-axis represents time. It sounds like the graph you are trying to implement does have time as its X-axis. This sounds more like a counting type of report.

Chandan M B
Feb 17 '23, 10:37 a.m.
Yes . I am trying to calculate number of defects against each development team how much days they are taking to move/close the defect in a graph so that the management can decide where exactly the delay..  New -> In Progress -> Review -> Closed

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.

Ask a question
Guidelines
FAQ
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
× 11,106
× 7,622
× 1,452

Question asked: Feb 17 '23, 6:54 a.m.

Question was seen: 4,267 times

Last updated: Feb 17 '23, 10:37 a.m.

Confirmation Cancel Confirm