I am using a Pivot table to show the number of visits a patient has been seen by a physician. How can I get the average number number of visits by provider? I can export to excel and calculate and get the following:
Provider
Total
Patient1
Patient2
Patient3
Total Visits by Patient
12
2
6
4
Dr. Feel Good
12
2
6
4
Avg Visits Per Patient
4
So the Average visits for Dr. Feel good = 4 (12Visits/3 patients).
How can I get the average for all of my Providers to show up in the Pivot? Also, is there a way to group by the number of visits...Say, Patient 1 had 2 visits, Patient 6 had 2 visits, and Patient 20 had 2 visits. I could sum the number of patients that had 2 visits and sum the patients that had 4 visits. Is there a way to do this in Qlik
