Calculate average of custom formula values in JIRA structure

[Adriana Domínguez Eguiarte]

Hi there!

I have got the following Jira structure:

• Epics
• User Stories
  • 3 US for each Epic
    • US 1 has 10 Story Points (weight)
    • US 2 has 20 Story Points (weight)
    • US 3 has 70 Story Points (weight)
• Sub-tasks
  • US 1 has 1 subtask, no Story Points defined
• Grouped by Components (8)

Context:

- I have a column type progress based on status, with different % for each Status.

This gives me for each of the 8 components:

-->the progress for each US

-->the progress of the Epic: average of each US progress

-->the progress of the component: average of the Epic progress

- I have a column, weighted progress, with the following formula: SUM{story_points*progress}/100

This gives me for each of the 8 components:

-->the weighted progress of each US

-->the weighted progress of the Epic: addition of each US weighted progress

--> the weighted progress of the component: addition of each Epic weighted progress 

The problem is, that I'd like to have for each component: the average of each Epic weighted progress instead.

In order to solve this, I have tried adding another column with a custom formula, but I can't solve the problem.

The formulas I have tried:

Formula 1)

if level=1:
AVG
{
SUM{story_points*progress}/100
}

Formula 2)

SUM{story_points*progress}/100/COUNT{epica}

I hope somebody can help me :)

Thank you in advance!!!

Best regards

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Adriana Domínguez Eguiarte 

You can try a formula like this: avg{storypoints}*progress without using the sum function. The formula will get the average Story Points value in each Epic's branch and multiply it on the Epic's own average status-based progress.

I hope tis helps. If you need further assistance with the formula or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)