Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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.