Using an existing filter in a column of Structure

Martin Härri
Contributor
September 5, 2023

I have a filter defined which extracts all issues in a sprint of the current increment (actually quite simple, it's "sprint = I27", which will return all issues where the sprint is "i27 sprint 1", "I27 sprint 2", or "I27 sprint 3".

Can I use that filter in a column of structure? I would like to count the story points only of those issues which are already assigned to a sprint, so the syntax should be something like "if the sprint of the issues meets the filter criteria then take the story points, otherwise take zero).

1 answer

0 votes
Ditte Simard
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2023

Hi @Martin Härri !

As of right now, there is no way to add a column that is populated by a filter.  However, you can get the results you are looking for in two ways:

1) Generate the Structure using the filter (easiest solution).  Use the "Insert" automation and populate it with your filter so it only looks at those issues.  The default column "∑ Story Points" will then sum up the Story Points correctly.

2) "Translate" your filter into a Structure Formula.  Here is a basic formula you can use to get yourself started:

/* Sum story points of issues that belong to specific sprints */

SUM#children {

IF(or(sprint.name = "i27 sprint 1", sprint.name = "I27 sprint 2", sprint.name = "I27 sprint 3"); storypoints)

}

Good luck!

Martin Härri
Contributor
September 29, 2023

Thanks a lot! What I eventually used is this formula 

case(sprint; "*I27*"; storypoints)

It takes the story point value if the sprint contains I27, otherwise the field is empty. When I sum this up I get to the desired result.

Downside is that the increment is hardcoded, I need to remember to change the formula every time we start a new increment

Like Ditte Simard likes this
Ditte Simard
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 30, 2023

Very clever formula you came up with!  :) good job figuring it out!  👏 

Like Martin Härri likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events