I need some help with a problem I have been struggling with.
In a rental shop I have rental orders with at CreatedDate, StartDate and EndDate. At the moment there is a join between CreatedDate and Date in the MasterCalender.
My challenge is to make a chart that shows me how many active Orders on given dates/periods back in time.
It’s important to be aware that not all orders have a DateEnd value since it’s still active and also that if a period is selected, orders with a StartDate before the selected period could be active in some or all the selected period.
