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).
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Very clever formula you came up with! :) good job figuring it out! 👏
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.