It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Feb 13 '18, 5:17 a.m.
question was seen: 1,052 times
last updated: Feb 13 '18, 10:05 a.m.

Related questions

FAQ - How this Forum works

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

0
Anurag Patel (21●3●63) | asked 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

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Matt Muller (598●1●35●74) | answered Feb 13 '18, 5:39 a.m.

Anurag,

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

Regards

Matt Muller

Comments
Anurag Patel commented 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 commented 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 commented 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 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.