Hi
I have column "Story Points SUM" but is it possible to create also "Story Points AVG". I mean that column not summarize not shows average results?
Hello @Visa Kask ,
Welcome to the Community!
It is possible to do this using Formula Columns. We just need to count the number of issues and divide the sum by the number returned.
A quick example is this:
with _children = COUNT#children{1}:
IF _children > 0:
SUM#children{storypoints}/_children
If an issue has "children" in the hierarchy, it will sum the story points and then divide by the number of children. Based on the hierarchy in your structure, it may need some adjustments to the modifiers (#children).
Please let me know if this helps!
Best,
David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.