I was trying to calculate average using the group by shape. I didn't look at detailed steps of the course. I ended up filling out properties on this shape by only setting the .Average property by using the "AVERAGE" option in the dropdown.
The options available are "Average", "Sum", "Count" etc. Should the shape not calculate average if I enter only one row just by setting .Average property? The shape is working only if I also set .Count and .Sum properties.