EyeQ: Non-Attended Bookings Report

Non-Attended Bookings Report

1. Log into EyeQ and select Query Builder > Create a Query.
2. Add the following content into the Select Fields:

Table	Fields
Bookings	Activity Activity Group Attended Contact ID Site Start Date Start Date Time
Contacts Detail	Full Name Home Email Mobile Telephone Telephone

 

1. Select Save and provide a name for the report (E.g. Non-Attended Bookings Report)
2. Click Save and Open and choose Export as Pivot.
3. Open the report in Excel remembering to Enable Content if prompted.
4. Clicking inside the Pivot table, distribute the following fields as below:

Filters	Columns
Bookings Detail Attended Bookings Detail Site	Bookings Detail Start Date
Rows	Rows Values
Bookings Detail Activity Group Bookings Detail Activity	SUM of Bookings Detail Contact ID

 

1. Update SUM of Bookings Detail Contact ID to COUNT of Subscriptions Contact ID.
2. Change the Bookings Detail Attended filter from (All) to (No).
3. Consider changing the Pivot Table Design to Show in Tabular View.
4. Consider re-grouping Bookings Detail Start Date by Days, Months and Years only.
5. Consider using Do Not Show Subtotals.
6. Using the Filter Bookings Detail Start Date, select a date range (e.g. This Month).