Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How do I Calculate average Impact from insights?

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?

1 answer

@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)

@Seth Mason 

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}

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you