Quantivly provides a rich set of built-in functions to calculate common operational metrics such as:
Number of appointments and exams
Schedule utilization and scanner utilization
Exam delays
... and many more
These functions go beyond simple counts:
✅ Respect configured operating hours
✅ Correctly clip exams and appointments at time boundaries
✅ Handle overlaps between appointments
✅ Account for patient Buffer time (pre/post exam) to model patient
✅ Support calculation of statistics restricted to specified time blocks
✅ Compute everything in your requested time zone, accounting for potentially scanners in different time zones
Behind the scenes, each function expands into highly optimized SQL (sometimes thousands of lines), validated against diverse synthetic scenarios for accuracy and consistency.
All functions live in the metrics PostgreSQL namespace.
Next :