llooker / google_ga360

Looker Blocks for Google Analytics 360
MIT License
39 stars 51 forks source link

Partition Date filtering on multiple days spills over on certain times #21

Open DillonMorrison opened 6 years ago

DillonMorrison commented 6 years ago

Meaning, running a query with partition date between 8/2 and 8/5 will give you a different total than individually summing 8/2 + 8/3 + 8/4 + 8/5. This is due to slight spillover of a few minutes (discrepancies under 1%).

Known limitation of using _TABLE_SUFFIX over multiple days with a dynamic filter.