Hi, I have the following dataset and I am really struggling to find the right calculation to get the result I am looking for:-
issueId | team | monthYear | workCategory | points |
---|
ME-44846 | TeamA | Apr-2023 | Engineering | 3 |
ME-45314 | TeamA | Apr-2023 | BAU | 4 |
ME-45739 | TeamA | Apr-2023 | Engineering | 3 |
ME-43757 | TeamA | Dec-2022 | Engineering | 3 |
ME-43760 | TeamA | Dec-2022 | BAU | 3 |
ME-43762 | TeamA | Dec-2022 | BAU | 2 |
ME-44256 | TeamA | Dec-2022 | BAU | 2 |
ME-44257 | TeamB | Apr-2023 | BAU | 2 |
ME-44331 | TeamB | Apr-2023 | Engineering | 3 |
ME-44571 | TeamB | Apr-2023 | Engineering | 3 |
ME-44583 | TeamB | Apr-2023 | BAU | 2 |
ME-44816 | TeamB | Dec-2022 | BAU | 2 |
ME-44830 | TeamB | Dec-2022 | BAU | 2 |
ME-44832 | TeamB | Dec-2022 | BAU | 2 |
ME-44835 | TeamB | Dec-2022 | Engineering | 0 |
I have a calculated field (sum(max({points},[{issueId}))) which sums the points per team. But I actually want to convert the points into a percentage based on the workCategory, team and month. ie Team A in Apr-2003 spent 60% BAU/40% Engineering which I can plot on a graph with the month as the x-axis.
I'd then like to sum the averages across teams to get a total percentage split on Engineering/BAU.
Is this even possible?