'Average' calculated incorrectly in Query Tool
Y
Yaswanth
The 'Average' column in the Query Tool ignores empty months. It should divide by the number of months being analyzed, not just the months with activity.
Example in the attachment:
It does 341.79 / 2 = 170.89, but it should be 341.79 / 7 = 48.82, which is the average spend across the months being viewed.
Log In
Y
Yaswanth
That works, thank you!
Din from Lunch Money
Hi Yaswanth,
In the Query Tool, you have the option to decide whether you'd like to see the average account for all time periods (regardless of activity), or to only account for active periods. You can manage this preference by clicking on the gear icon at the top right of the table, next to the filter icon.
Please let me know if this helps! :)