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

How to Calculate number of days of work-item in as per the state.

Questions
Tags
Users
Badges
Anurag Patel
(21●8●68) Feb 13 '18, 5:17 a.m.

Hi,


I have to calculate the : 
1. Total number of Task work item in-Progress state.
2. Total number of days Task work item in in-Progress state.

Can we calculate the number of days and total count of work item using Report builder.
Which query we need to create in report builder for above requirement.

Thank in Advance

0 votes

1 answer
3,821 views
0 votes

One answer

Permanent link
Matt Muller
(598●1●36●74) Feb 13 '18, 5:39 a.m.

Anurag,

What version of RTC are you using and have you looked at JRS?

Regards

Matt Muller

0 votes

Comments
Anurag Patel
Feb 13 '18, 7:16 a.m.

 Hi Matt,


I am using 6.0.2. I tried using JRS and got the result.

Thanks

Anurag Patel
Feb 13 '18, 7:21 a.m.

Is it possible using JRS to get the below result in single query:

1. Task work item more than 5 days in New state.
2. Defect work item more than 10 days in New/In progress state

I tried to create the above query using group option in JRS but not getting any result. Is it correct way of query or I miss something.

Please suggest.
Thank You.

Matt Muller
Feb 13 '18, 10:05 a.m.

You can use a simple query for that?.. but the results would be in two different widgets

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

Question asked: Feb 13 '18, 5:17 a.m.

Question was seen: 3,821 times

Last updated: Feb 13 '18, 10:05 a.m.

Confirmation Cancel Confirm