How can I group lookupIssues results by component, and take the size of the largest group?

Aidan Follestad

The main objective is that I want to sum points for tickets in an epic, and assign that to the epic Story Points field.

However, my project uses components to separate tickets by platform… I want to take the sum of the platform that has the most overall points, and assign that to the epic.

Basically, I want to use lookupIssues, group the results by component, and use `MAX()` to get the largest sum. But the aggregation part has proven difficult to figure out!

Tim C_i4lu7p

Hi @Aidan Follestad 

Welcome to the Atlassian community.

I don't know how many components you've got - but here's one potential approach if it's a manageable number ...

Do a lookup using JQL for the data sets for each of your components and create a smart variable for each total of story points - e.g.  ....

Lookup issues based on JQL #1 ...
"project = XYZ and component = ABC and "story points" is not empty"
+ Create variable LUA = {{lookupIssues.story points.sum}}

Lookup issues based on JQL #2 ...
"project = XYZ and component = DEF and "story points" is not empty"
+ Create variable LUB = {{lookupIssues.story points.sum}}

Lookup issues based on JQL #3 ...
"project = XYZ and component = GHI and "story points" is not empty"
+ Create variable LUC = {{lookupIssues.story points.sum}}

You can then find the maximum from each of the smart value variables ...

create variable MyMAX = max(LUA, LUB, LUC)

Then you'd edit the Story points value for the required Epic and add the MyMAX variable.

Obviously, someone else may have a smarter solution - but hopefully this helps.

Thanks,

Tim C