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
