Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Analytics Pivot vs View

General Discussion

Last Post by angelahunsberger 9 years ago

3 Posts

3 Users

0 Reactions

60 Views

RSS

dmcintire

(@dmcintire)

Posts: 48

Trusted Member

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

mdoak

(@mdoak)

Posts: 92

Estimable Member

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

angelahunsberger

(@angelahunsberger)

Posts: 290

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
7 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0