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

Hareesh Jairaj (83●18●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

permanent link

Jackie Albert (1.6k●1●48●46) | 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

It's all about the answers!

Related questions

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

One answer

Your answer