I have data as below. Patients can have several visits of various types. Some visit types may repeat (Initial Visit is the exception).
I'm using Pivot Tables to analyze these data. How can I answer questions like:
1. Among patients who had Well-Being visits, how many had a Surgery visit? [The answer is 2 patients had Well-Being visits, 1 of whom has had a Surgery visit.]
2. What is the average number of days that passed between the Initial Visit and the Surgery Visit?
To answer questions like these via the pivot, I suspect I need to restructure the data somehow, but I'm not entirely sure of the best way of even if that's necessary.
Thank you for any suggestions.
Bookmarks