It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×12,008
×359
×201
×37
×7
×1

question asked: Jan 30 '18, 5:37 a.m.
question was seen: 3,277 times
last updated: Feb 03 '18, 6:58 a.m.

Related questions

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

0
Hareesh Jairaj (83●22●38) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jackie Albert (1.6k●1●49●47) | 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.