Forum Discussion
Data Missing When Filtering
In case anyone else has the same issue, it seems Google Analytics uses "sampling" with a large dataset and does not show everything.
Hi v-alq-msft ,
Thanks for taking a look. I tried that and didn't get the desired result.
It doesn't seem to pull all of the data unless it's filtered by a specific date first (but I want all dates). Here is a link to sample PBIX file: https://saratogaperforming-my.sharepoint.com/:u:/g/personal/ebrower_spac_org/EUruWtuvQW9GizR5Pc5IkRwBSr8qRgu4szs9qX_EoAr3jA?e=mijj5Q
12/3/19 was my example - I'm currently expecting about 85 rows, but getting 20.
If you just look through the data for that date where Event Action equals TM PV and Page contains ccauth, you only see 20 rows. But if you filter by date 12/3/19 first, then by Event Action and Page, you get 85 rows.
Thanks!
Just a suggestion, but have you checked into the date statement? Could it be a simple difference of european date vs american date format in your data load or filter. maybe the interpretation of date is misaligned?
Not sure why GA would pull in a variety of dates... it seems to be fine when filtering by date first - in fact, that's the only way to get the desired # of rows. It doesn't give all of the rows of data unless it's filtered to a date.
Wondering if anyone has any ideas on why this is happening?
Thanks
In case anyone else has the same issue, it seems Google Analytics uses "sampling" with a large dataset and does not show everything.