To export your appointment report as a CSV file:
Go to Calendar Tab,
Then click on the More Option icon, and select the Appointment Report option.

3. This pop up opens :

4. Select the criteria you want and click on Export.
Tips: to analyse only completed appointments, make sure to exclude all cancelled appointments and no-show appointments.
5. Then click on the link "Click here to download the report", and the download starts.