Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following tables:
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?