cancel
Showing results for
Did you mean:
See all
##### Top groups
Explore all groups

# How do I Calculate average Impact from insights?

Seth Mason April 14, 2022

There's a built in function to rollup/sum the impact's from insights, how can I calculate the average impact based on the number of insights?

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 15, 2022
Seth Mason April 15, 2022

@Tanguy Crusson Thanks for the video, but I'm trying to get the average impact for an idea (not across ideas).

If I had an idea with three insights:

Insight A: Impact 5

Insight B: Impact 1

Insight C: Impact 4

How can I get the average impact of this idea? (Avg: 3.3)

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 19, 2022

Ah ok, I see!

In that case what you can do is create 2 fields, one that rolls up the impact, and the other one that calculates the average:

• the first one, called "Insights impact"
• Field type: formula
• formula type: roll-up
• input: Insights > Impact
• The second one called "Insights average"
• Field type: formula
• Formula type: write your own
• the formula: {Insights impact}/{Insights}