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
Query #1121 vs #1097
Re: Query #1121 vs #1097
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.
Re: Query #1121 vs #1097
I forgot to add that I (Excel) counted the zip codes where "production>0" in #1097, which reduced it from 5191 to 1249.
Re: Query #1121 vs #1097
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.