You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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".
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,
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:
And here is my SQL query:
SUM(T1.'Story Points') AS 'Sum of Story Points'
WHERE T1.'Issue Type' IS "Enabler"
GROUP BY T1.'Labels'
You may also adjust this query for other conditions and aggregation purposes.
Hope this helps your case.