The group nesting and sum features in Airtable are slick and potentially very useful, but not being able to display a weighted average in the groups’ summary bars is really painful. The solution to this problem appears, at least to me, to be very sim...
The result in your example should be $15,341 / 7 = $2,191.57
$1,058.58 is not even close. That’s why it’s a bad number.
I’m not looking for a simple average. I’m looking at a total spent for an advertisement campaign vs. the results it produced. If a...
You could create another view with a filter that excludes unranked events. Only problem is that the unranked events wouldn’t appear when you expand the group out.
