This workbook contains a query that displays the attendance and cancellation rate from the previous year compared with that of the current year. The key figure Attendance per Cancellation displays the number of attendances per one cancellation, thus indicating the ratio of cancellations to attendances. The key figure Cancellation Rate, on the other hand, indicates the percentage of cancellations to total bookings.
The workbook contains the following query:
Technical Name of Query
Name and Short Description
Attendance and Cancellation Rate