I have 2 events, 1 tracking successful bookings an...
# questions
b
I have 2 events, 1 tracking successful bookings another one tracking cancellations of these bookings. both events have a property called datetime which refers to the appointment datetime. See Screenshot... As you can see 56 Bookings were made for 9pm and 10 Bookings got cancelled for 9pm appointments. 121 Bookings came in for 8pm and 18 got cancelled and so on. Desired outcome is to put those numbers in relation and calculate how many % of bookings broken down by hour of day got cancelled. Example: 17.85% (10*100/56) of the 9pm Appointments, 14.87% of the 8pm appointments and so on have been cancelled. Any ideas? Thanks much 🙏