Anna can compute a number of different calculations on the fly. In this article, we will be exploring averages in more detail.
What do you mean by averages?
When you ask a question like “Average sales over time',' Anna calculates a simple average by dividing the total sales by the number of rows in your dataset.
You can also ask Anna about the average sales for each value within a segment! For example, you could ask Anna to show you the average sales by department, average profit by product, average expenses per business trip etc.
What other averages can Anna do?
Anna can also calculate a complex average. Anna calculates a complex average by dividing the total sales by the total unique rows in your dataset.
In this example, Anna shows that in July 2019, the average sales per customer were $50. A complex average can be helpful when you want to understand the average sales per customer, average spend per contract, average expense per employee etc.
What about weighted averages?
Anna can calculate weighted averages, but there are two things to note.
1. Your data must be structured in a way that captures the weight of each element, for example:
2. Anna won’t automatically know to calculate a weighted average, but this is something we can set up for you behind the scenes. Please contact us at firstname.lastname@example.org if you are interested in setting up weighted averages in your data.
In this example, you would be able to explore the weighted average for a particular activity. A weighted average can be helpful in education if you want to calculate grades, in finance if you want to compare average bond yields, in manufacturing if you want to see cost differentiations.
If you have any questions, please contact us at email@example.com.