Is it possible to get an average number of events per day per week/year/month.
I want to monitoring our progress in number of orders in the month with an average orders per day. This way I can see if we are on track to outperform previous months. I can do a formula: Order Completed / 30. But this has 2 major downsides:
- Not every month is 30 days
- It makes the current month data useless, because it also devides it by 30, while this month is still ongoing
Can’t I do a a formula: Order Completed / # (passed) days in the month or something?