Stats: Incorrect click count totals are shown when there is a large number of sources

[jsnmoon]

Steps to reproduce

• Open the traffic dashboard at /stats/day/:siteSlug for a site with over 2000+ sources for its Clicks stats module.
• Try viewing weeks, months, and years.

What I expected

• For click counts for a given week to be less than or equal to those for a given month containing that week.

What happened instead

• Click counts for a given week were greater than those for a given month containing that week. In other words, we are showing incorrect counts on the traffic dashboard.

Context / Source

Customer Report: 7270155-zd-a8c Discussion: @kangzj mentioned that this is happening because we're only using the top 2000 records to calculate count totals (p1702517852842369/1701768705.947649-slack-C0438NHCLSY).

[github-actions[bot]]

Support References

This comment is automatically generated. Please do not edit it.

• [ ] 7270155-zen

[liviopv]

📌 ACTIONS

• Triaged

📌 Message to Author @jsnmoon since it's on your team's board already and it's not feasible to reproduce this one manually, I'm going to mark as triaged. Let us (Dotcom PA Guild) know if you need further investigation on this and how we can help.