Average is returning SUM instead of an Average
I'm setting up a single value card and I have a column that is full of numeric values.
When I set up the column as the Value of the chart and set the Calculation to "Average" the single value presented is a sum of the values, not an average (if I change to "Sum" i get the exact same value).
Is there some trick to using average in a chart? Why is it not working?