How do I Calculate average Impact from insights?

[Seth Mason]

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]

Hi @Seth Mason here's what you can do: https://www.loom.com/share/45661bf18f5745c8b2d6184ef3fcae54

[Seth Mason]

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

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