1 of 1 people found this helpful
You could try measuring the count of booking ids against Month of Check in and place booking date on colors to define distribution.
It's a little messy but you could clean it up by creating a months ago field.
IF DATEDIFF('month',[Booking Date],[Check In Date]) < 5 THEN STR(DATEDIFF('month',[Booking Date],[Check In Date]))
ELSE '5+' END
I think what you ve done is a much better idea by grouping months together and use it as "N' months ago.
Is there a possibly a way to work out a scatter plot where in I can work out bookings in one month (for eg jan) and checkins scattered over the year ( Jan - Dec) . I tried but can t work out a scatter plot (attached)
I will go with the bar chart that has months ago field