Re: How to create a query that shows Average revenue per patient
Thank you for your question, I don't believe it is currently possible to achieve what you are asking for in the above request. You could run a report that shows payment totals for each patient, on a patient basis and work at an average, but this would need running for each patient, so my only suggestion is you could do this for a snapshot of the clinic, not for every patient.
Feel free to log an idea for the report that you require and that will allow other users to comment and vote on it.
If I can help in any other way please feel free to let me know.