Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,363,771
Community Members
 
Community Events
168
Community Groups

Using Table Transformer to show counts per row based on cell value

My table transformer is giving me the below output,

Key
Objective
Epic
Team/s
Fix Version/s
ABC-1Objective 1Epic 1Sharky Spark 
ABC-1Objective 1Epic 2  
ABC-6Objective 6Epic 5Spark 
ABC-9Objective 9Epic 10Anvil Phoenix Vortex2022.11.29

I would like to get a count on rows that have NULL values grouped by Objective column i.e.

Key
Objective
Unassigned Team/s
Unassigned Fix Version/s
ABC-1Objective 11 2
ABC-6Objective 60 1

1 answer

Hi @Samata Sabala,

Please try the following SQL query:

Fri 7-1.png

SELECT T1.'Key',
SUM(IF(T1.'Team/s' IS NULL, 1, 0)) AS 'Unassigned Team/s',
SUM(IF(T1.'Fix Version/s' IS NULL, 1, 0)) AS 'Unassigned Fix Version/s'
FROM T1 GROUP BY T1.'Key'

Fri 7-2.png

Hope this helps your case.

 

UPD. Forgot about the "Objective" column: add it to the query if you want to show this data as well.

SELECT T1.'Key', T1.'Objective',
SUM(IF(T1.'Team/s' IS NULL, 1, 0)) AS 'Unassigned Team/s',
SUM(IF(T1.'Fix Version/s' IS NULL, 1, 0)) AS 'Unassigned Fix Version/s'
FROM T1 GROUP BY T1.'Key', T1.'Objective'

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events