It's all about the answers!

Ask a question

Report for viewing story points progress per team member


Niall O Shea (112) | asked Feb 07 '17, 7:04 a.m.

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

One answer



permanent link
Elisabeth Carbone (616108) | answered Feb 07 '17, 10:43 a.m.
JAZZ DEVELOPER

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

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.