Filter appointment reports by date range | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/filter-appointment-reports-date-range Publisher: Pixie Technologies LLC Appointments (https://pixiecrm.com/help-centre/topic/appointment) & Scheduling (https://pixiecrm.com/help-centre/topic/scheduling) · How-to guide Filter appointment reports by date range Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Apply a defined reporting period and compare like-for-like appointment performance. Audience: Staff who manage appointments; Feature: Report date range; Module v1.3.6; Where to goAppointments (https://pixiecrm.com/help-centre/topic/appointment) > Reports (https://pixiecrm.com/help-centre/topic/report) Before you startThis guide follows the supplied Pixie CRM Appointments (https://pixiecrm.com/help-centre/topic/appointment) & Scheduling (https://pixiecrm.com/help-centre/topic/scheduling) module version 1.3.6. The relevant access is Appointments (https://pixiecrm.com/help-centre/topic/appointment): View Reports (https://pixiecrm.com/help-centre/topic/report). A menu, button, provider (https://pixiecrm.com/help-centre/topic/provider), time slot (https://pixiecrm.com/help-centre/topic/scheduling) or client (https://pixiecrm.com/help-centre/topic/customer) action can remain hidden when the signed-in user lacks the required permission, the module setting is disabled, the related record is in an ineligible state, or availability (https://pixiecrm.com/help-centre/topic/availability) validation rejects the request. What you’ll accomplish Apply a defined reporting period and compare like-for-like appointment (https://pixiecrm.com/help-centre/topic/appointment) performance. It uses Pixie CRM's permission-aware appointment (https://pixiecrm.com/help-centre/topic/appointment), availability (https://pixiecrm.com/help-centre/topic/availability), status and integration flow rather than an unconnected diary entry. How it works The report (https://pixiecrm.com/help-centre/topic/report) controller accepts supported date boundaries and applies them to its appointment (https://pixiecrm.com/help-centre/topic/appointment) queries. Period comparison uses separate current and previous datasets according to the selected range. Date interpretation should be checked against the CRM and module timezone (https://pixiecrm.com/help-centre/topic/timezone). Follow these steps - Go to Reports (https://pixiecrm.com/help-centre/topic/report). - Select a preset or enter the start and end dates. - Apply the filter. - Verify the period displayed above charts/tables. - Export or compare only after checking the boundaries. Settings to check Start dateInclusive lower reporting boundary according to query logic. End dateUpper reporting boundary. Comparison periodPrior period used by comparison data. Timezone (https://pixiecrm.com/help-centre/topic/timezone)Context affecting date classification. Check it worked After this workflow completes, Pixie CRM keeps the appointment (https://pixiecrm.com/help-centre/topic/appointment) and its supported relationships connected. Reopen the appointment (https://pixiecrm.com/help-centre/topic/appointment) and verify the saved status, date, timezone (https://pixiecrm.com/help-centre/topic/timezone), customer (https://pixiecrm.com/help-centre/topic/customer) or lead (https://pixiecrm.com/help-centre/topic/lead), service (https://pixiecrm.com/help-centre/topic/service), provider (https://pixiecrm.com/help-centre/topic/provider), attendees, reminder (https://pixiecrm.com/help-centre/topic/reminder) state, calendar or meeting reference, invoice (https://pixiecrm.com/help-centre/topic/invoice) reference and history that apply to this feature. External email (https://pixiecrm.com/help-centre/topic/email), SMS (https://pixiecrm.com/help-centre/topic/sms), Google, Microsoft or payment (https://pixiecrm.com/help-centre/topic/payment) outcomes must be checked separately from the Pixie CRM database save. - Open the saved appointment (https://pixiecrm.com/help-centre/topic/appointment) and confirm the final status and source. - Check (https://pixiecrm.com/help-centre/topic/check) the participant, provider (https://pixiecrm.com/help-centre/topic/provider), timing and timezone (https://pixiecrm.com/help-centre/topic/timezone) from the full detail page. - Review the relevant table filter, calendar, history, report (https://pixiecrm.com/help-centre/topic/report) or linked invoice (https://pixiecrm.com/help-centre/topic/invoice) instead of relying only on a success message. Common mistakes to avoid - Do not compare a partial month with a complete month without explanation. - Check (https://pixiecrm.com/help-centre/topic/check) appointments (https://pixiecrm.com/help-centre/topic/appointment) near midnight. - Clear old filters before creating a new report (https://pixiecrm.com/help-centre/topic/report). - Use the least destructive correction and retain the appointment (https://pixiecrm.com/help-centre/topic/appointment) history when the booking existed operationally. - Never bypass a permission, availability (https://pixiecrm.com/help-centre/topic/availability), approval (https://pixiecrm.com/help-centre/topic/approval), client (https://pixiecrm.com/help-centre/topic/customer)-access or verification control by changing an unrelated route or setting. Scheduling (https://pixiecrm.com/help-centre/topic/scheduling) and data safetyAppointment (https://pixiecrm.com/help-centre/topic/appointment) changes can notify customers (https://pixiecrm.com/help-centre/topic/customer), reserve provider (https://pixiecrm.com/help-centre/topic/provider) time, update remote calendars, create meeting links or invoices (https://pixiecrm.com/help-centre/topic/invoice) and alter reports (https://pixiecrm.com/help-centre/topic/report). Confirm the exact record, timezone (https://pixiecrm.com/help-centre/topic/timezone), status and recipients before saving. Browse connected topics:report (https://pixiecrm.com/help-centre/topic/report)appointment (https://pixiecrm.com/help-centre/topic/appointment)scheduling (https://pixiecrm.com/help-centre/topic/scheduling)timezones (https://pixiecrm.com/help-centre/topic/timezone)invoice (https://pixiecrm.com/help-centre/topic/invoice)payment (https://pixiecrm.com/help-centre/topic/payment)check (https://pixiecrm.com/help-centre/topic/check)approval (https://pixiecrm.com/help-centre/topic/approval)service (https://pixiecrm.com/help-centre/topic/service)provider (https://pixiecrm.com/help-centre/topic/provider)availability (https://pixiecrm.com/help-centre/topic/availability)booking form (https://pixiecrm.com/help-centre/topic/booking-form)reminders (https://pixiecrm.com/help-centre/topic/reminder)feedback (https://pixiecrm.com/help-centre/topic/feedback) Related guides Use the Appointments analytics dashboard (https://pixiecrm.com/help-centre/use-appointments-analytics-dashboard)Troubleshoot appointment timezone and date display (https://pixiecrm.com/help-centre/troubleshoot-timezone-and-date-display)Review staff performance and popular services (https://pixiecrm.com/help-centre/review-staff-performance-and-popular-services)Filter appointments by status, date and source (https://pixiecrm.com/help-centre/filter-appointments-by-status-date-source)Use Appointments history (https://pixiecrm.com/help-centre/use-appointments-history)Edit appointment history notes (https://pixiecrm.com/help-centre/edit-appointment-history-notes)Enable the Today's Appointments widget (https://pixiecrm.com/help-centre/enable-todays-appointments-widget)Enable the Upcoming Appointments widget (https://pixiecrm.com/help-centre/enable-upcoming-appointments-widget)