Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have the following tables:
Sales:
LOAD
ID,
Shop,
Category,
Date,
Sales;
Calendar:
LOAD
Date,
WeekDay,
NrWeek;
What I need to get is an average per week day of the whole year.
In the app I've created a table to check everyday if some sales are missing from the dataset:
Aside I created another table where I would like to have the average per week day:
AvgSales = Avg(Aggr(Sum(Sales),WeekDay)
As you can see this is not the average but the sum.
What can I do to get the average?
Thanks in advance.
If I export the data to Excel and create a pivot table that includes the WeekDay and Average of Sales, the results are as follows (the same as in my previous post). So how exactly are you calculating the average?