Structure column: Story Points SUM and AVG

[Visa Kask]

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?

[David Niro · Accepted solution]

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