I want to Thank Alexander with product support for pointing out this solution:
1. Enter any missed appointment date into a chosen "misc field" under a patient's demographics tab. It needs to be the same field in every patient's chart. We chose misc field 2.
2. When you need to calculate the no show rate, you run a report in AC. Category: demographics, Field: misc field, operator: <>, value:"blank". This will return any patient that does not have an empty misc field. You will also need also need to add a field to define your date range.
3. check the "show all query results" to show all the information you need.
4. export to a an xls file.
5. From excel you can use the data function to change any text to columns for patient's with multiple misses, etc.
The big limitation on this solution is that it only works going forward.
