I have a question about counting invoices. I am currently making an overview.
I actually have 2 questions:
1. some customers order 2x a day because they have forgotten something. This obscures the data. So I only want to count the first invoice per day per customer. How can I solve this?
2. Furthermore, I want to calculate the number of orders per week in the last 6 months (average) and offset this against the number of orders per week in the last month (also average). How can I calculate this? Thanks in advance!