Just looking at the formula, looks like the syntax is a bit off. Instead of:
SUM([# Pitches] * COUNTD([What is your last name?]))/COUNTD([What is your last name?])
This should work:
(SUM([# Pitches]) * COUNTD([What is your last name?]))/COUNTD([What is your last name?])
SUM and COUNTD are functions that aggregate data (the dimension or measure you put within parenthesis after the function name). On your formula, the SUM function was missing a parenthesis.
Hope this helps!
Hi Santiago - thanks so much for your help!
Tried what you said but I'm not sure it's calculating correctly. The averages at the top of each bar don't seem correct... Also, I just need one average across ALL the columns. For example, I would guesstimate that the average is somewhere between 10-15 pitches.
Does that make sense?