How to get average order per week

[#1]

Hi,

I have a qlik view application that shows the total orders ordered per day (or week, month, etc).

My customer want to have an gauge 'Orders this week vs Average orders per week'. I am wondering or some knows how I can determine the average amount of orders per week?

Does someone have an idea?

[#2]

Together with my collague I have found a solution that can also be useful for you:

Average per week = Num((Sum(OrderCounter) / Count(Distinct WeekYear)), '#####.')

Together with 'set analysis' that fix to the last week you can get the orders this week vs average orders per week.