Different calcul in one pivot table

Lucas HILLORION
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 23, 2023

Hello, I'm trying to display my global sum of story points, but also the detail of how many belong to my Implem team and Func Team.

I only manage to do so by doing 3 different pivot tables, with each one its own "search request".
Capture.PNG
Is there a way, to do only one Pivot table, filled with 3 differents calculations on 3 differents column ?

The search are as below : 
Total Load : Project = X and IssueType = Enabler and Sprint = "Sprint 1"
Implem : Project = X and IssueType = Enabler and Labels = Implem and Sprint = "Sprint 1"
Func : Project = X and IssueType = Enabler and Labels = Func and Sprint = "Sprint 1"

 

Thanks in advance,

1 answer

1 accepted

2 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 24, 2023

Hi @Lucas HILLORION ,

You may try the Table Transformer macro to group your issues.

Here I have a table that shows me all the issues from the Project X:

Thu 1-1.png

And here is my SQL query:

SELECT T1.'Labels',
SUM(T1.'Story Points') AS 'Sum of Story Points'
FROM T1
WHERE T1.'Issue Type' IS "Enabler"
GROUP BY T1.'Labels'

Thu 1-2.png

You may also adjust this query for other conditions and aggregation purposes.

Additionally you may wrap this table in the Table Filter macro (directly on Server/Data Center or via the Table Toolbox on Cloud) to count totals.

Hope this helps your case.

Lucas HILLORION
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 25, 2023

Thank you very much for your answer

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events