Attendance and Cancellation Rate

Use

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.

Structure

The workbook contains the following query:

Technical Name of Query

Name and Short Description

0PE_C01_Q003

Attendance and Cancellation Rate