Average Daily sales by Year , Month and Day in a bar graph

[Qlikuser09]

Hi, I want to calculate the average daily sales by year and  Month in a drill-down dimension. 

Count({< DateType = {'Sales Date'}>} AC Number])-  gives the count of the sales for my data. Attached is the sample data . 

[Andrea_Bertazzo]

Hi @Qlikuser09 

you need a Year, Month and Day field to do this. Then you can use a formula like:

Avg({$<Year={2022} >} Sum(sales))

to calculate the average of sales of year 2022.