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

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

Questions
Tags
Users
Badges
Hareesh Jairaj
(83●22●38) 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

0 votes

1 answer
3,470 views
0 votes

One answer

Permanent link
Jackie Albert
(1.6k●1●49●47) Jan 30 '18, 10:02 a.m.

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

0 votes

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

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 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
× 12,033
× 361
× 201
× 37
× 7

Question asked: Jan 30 '18, 5:37 a.m.

Question was seen: 3,470 times

Last updated: Feb 03 '18, 6:58 a.m.

Confirmation Cancel Confirm