It's all about the answers!

Ask a question

How can we sum columns in JRS? Unable to perform SUM Operation in SQL - JRS


Hareesh Jairaj (832138) | asked Jan 30 '18, 5:37 a.m.

 Hi all,


I am trying for a JRS report by which should display the TOTAL sum of artifacts count as shown in table below
I want to sum all the workitems in New state and Sum the workitems count which are New,In-progress state of a particular Workitem Type.

Tried editing Advanced query in JRS. Data warehouse is the data source. SUM operation is not throwing  as expected in the query. Help on this request qould be appreciated. 


Type

State count (New)

State count(Inprogress)

Total


Defect

11

55

66

Task

66

32

98

Incident

11

53

64

Story

23

34

57

                Total

111

174

285   
                    

Regards,
Harish

One answer



permanent link
Jackie Albert (1.6k14946) | answered Jan 30 '18, 10:02 a.m.

 Crosstab capability isn't available in JRS (although I would love it too!). 


Comments
Fariz Saracevic commented Feb 03 '18, 6:58 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

Jackie is correct. Crosstab capability is not supported in JRS yet but we do have enhancement request. You can find details at https://jazz.net/jazz/web/projects/Jazz%20Reporting%20Service#action=com.ibm.team.workitem.viewWorkItem&id=361055

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.