Booking Curve with Optimal Accuracy

Hi All,


I am have currently been tasked with creating a booking curve dashboard, the filters will be the resort and month and the graph will show lead time (days between the booking being made and the date of arrival) and the number of nights booked. A simple task on the surface but the challenge I am facing is trying to account for the fact that the lead time may vary vastly within a month. For example school holidays will have longer lead times as people book these further in advance, the same with public holidays.


Any suggestions here of a function that could help with this would be appreciated, at the moment the only one I have come across is the rolling average using mean/offset list.

This topic has been closed for comments