Report Builder : How to do reporting between user preferred 2 states in a workitem
![]() Hi,
My scenario is - Assume we have Change Request workitem
State workflow is New -> Analyze
Analyzed -> Start Working
In-progress -> Review
In Review -> Complete
Now with the data warehouse I am able to get the days of the workitem took for state transition.
My use case is something I am interested to do get number of days it took Analyzed -> Review (State 1 -> State m)
or (State m -> State n).
Any help would be appreciated.
Regards,
Chandan
|
2 answers
![]()
David Honey (1.4k●1●7)
| answered Dec 07 '21, 6:11 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I don't think this is possible in Report Builder. It uses
|
![]()
David Honey (1.4k●1●7)
| answered Dec 09 '21, 1:36 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I found the following might be a start. For a Data Warehouse data source in Report Builder, you can select Work Item and then add a traceability link to Work Item Status History:
That will give you a report that looks like this:
![]() Comments Thanks David.
But user wants to know based on dynamic input of a status.
Example : In your case
Status 1 - Closed
Status 2 - New
Then I have to sum New + In Progress + Closed = Total
What do you mean by "dynamic input of a status".
|