Query #1121 vs #1097

For users or potential users.
Post Reply
Erik@AD
Posts: 15
Joined: Thu Jun 09, 2016 12:52 pm

Query #1121 vs #1097

Post by Erik@AD » Wed Nov 23, 2016 11:30 am

I am trying to get some demographics by zip code and these queries return quite some different values.
1249 vs 1337 for a certain zip code for example.

My questions are:
Which query is most accurate?
What is causing these significant differences?

Thanks,

-Erik

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Query #1121 vs #1097

Post by cmcgehee » Wed Nov 23, 2016 12:29 pm

Both queries are equally accurate; they are just measuring different things. #1121 will count a patient only if they had a completed procedure in the date range. #1097 will display a patient if their zip code is in the list supplied regardless of if they have any completed procedures.
Chris McGehee
Open Dental Software
http://www.opendental.com

Erik@AD
Posts: 15
Joined: Thu Jun 09, 2016 12:52 pm

Re: Query #1121 vs #1097

Post by Erik@AD » Wed Nov 23, 2016 1:12 pm

I forgot to add that I (Excel) counted the zip codes where "production>0" in #1097, which reduced it from 5191 to 1249.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Query #1121 vs #1097

Post by cmcgehee » Wed Nov 23, 2016 1:48 pm

That sounds like your numbers match. Technically it is still possible for them not to match after you remove patients with $0 production. If a patient's only completed procedures have procedure fees of $0, they would appear on #1121 but then get filtered out of #1097.
Chris McGehee
Open Dental Software
http://www.opendental.com

Erik@AD
Posts: 15
Joined: Thu Jun 09, 2016 12:52 pm

Re: Query #1121 vs #1097

Post by Erik@AD » Wed Nov 23, 2016 2:36 pm

Ok thanks.

-Erik

Post Reply