Hello crowd,

I need your swarm knowledge for this issue:

I selected July + August in date picker, which is 9 calendar weeks.

My objective is to calculate the average sales orders per customer per calendar week.

You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.

The challenge is, that not every customer is ordering in every week.

My question is: 

How do I get the total number of calendar weeks (9) from the date picker in my formula?

I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.

Best, Thomas