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

Report for viewing story points progress per team member

I currently have a view of the status of the whole team with Story Points Progress report 

But I'm wondering if there's a predefined report which shows the Story Points Progress for each team member or if I can create this report using Report Builder. 


The version of RTC is 6.0.1

0 votes



One answer

Permanent link

I am not aware of such a predefined report but you can build one in Report builder.

I create a simple report where I list the default attributes and add story points and owner, scope one Project Area filter on Epic and Story. This gives me a query to start with, it contains the correct table names, attribute names, joins and the id for the Project Area.

Under Format results - Advanced I edit the query
Original query:

SELECT DISTINCT T1.PROJECT_NAME,
       T1.REFERENCE_ID,
       T1.NAME AS URL1_title,
       T1.URL AS URL1,
       T1.REQUEST_TYPE,
       T1.STORY_POINTS,
       T2.FULL_NAME
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RIDW.VW_RESOURCE T2
ON T2.RESOURCE_ID=T1.OWNER_ID
WHERE T1.PROJECT_ID = 0  AND
(  (T1.REQUEST_TYPE = 'Epic' OR T1.REQUEST_TYPE = 'Story' )
) AND
(T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL

Edited to:

SELECT SUM (T1.STORY_POINTS) as Points,
       T2.FULL_NAME
FROM RIDW.VW_REQUEST T1
LEFT OUTER JOIN RIDW.VW_RESOURCE T2
ON T2.RESOURCE_ID=T1.OWNER_ID
WHERE T1.PROJECT_ID = 0  AND
(  (T1.REQUEST_TYPE = 'Epic' OR T1.REQUEST_TYPE = 'Story' )
) AND
(T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL) group by T2.FULL_NAME

0 votes

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
× 230

Question asked: Feb 07 '17, 7:04 a.m.

Question was seen: 2,361 times

Last updated: Feb 07 '17, 10:43 a.m.

Confirmation Cancel Confirm