Week day year Average

[luca_bellotti]

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.

[rbartley]

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?