Notifications
Clear all
General Discussion
3
Posts
3
Users
0
Reactions
78
Views
Topic starter
I am using the Analytic pivot table to get a number of patient visits. I wanted to use the Analytics view to give me a list of all those patient visits and then count the individual patient names to get a count of the individual patients seen. The problem I am running into is that I am getting a number of patient visits almost twice as big using the view as I am using the pivot table. I am just filtering by Service Dates Primary Insurance Carrier and Patient Name on the view side and Service Dates Primary Insurance Carrier and Num Pt Visits on the Pivot side. Am I missing something? Any ideas would be great.
Posted : September 22, 2015 7:09 am
Which view are you using? If you're using a view that goes down to a lower level of granularity than just the visit - like Patient Visit Charges or Patient Visit Payments, you might be getting a row for each charge or each payment - ie more than one row for each visit.
You might be able to get what you want by manually editing the query and putting the word "distinct" after select in the SQL statement.
Or I think if you just use the patient visit balance summary view, that would probably be the right one and would give you one row per visit.
Posted : September 22, 2015 8:42 am
Hey, I"ve got some documentation that may help you regarding the definitions of the analytic fields available. Shoot me an email and I'll send it all right over. [email protected]
Posted : September 24, 2015 1:57 am
