Usage report obtained from Popularity Trends link generates incorrect statistics
The spreadsheet generated from the usage report link under Popularity Trends generates incorrect statistics for unique users in the section that is aggregated for monthly statistics. The spreadsheet appears to sum up the unique users for each day in the month, rather than calculating the unique users across the entire month. This will tend to greatly exaggerate the unique users per month.
Emma Leonard commented
I am also experiencing the same issue with the number of page hits not matching the popularity trend reports, the report shows 0 for all days.
It is July 2019 and it seems like MS folks still cannot see the difference between a 'number of unique users per month' vs 'a sum (for entire month) of numbers of unique users per day'. The 'Popularity Trends' report in Sharepoint basically shows absolute stupidities. We are not speaking about some minor imprecision - the exaggeration level can be 20x (sic! TWENTY TIMES) - in an environment where we have 20 working days in a month (or 31x - if the operations runs 7d/week). Microsoft! Fix it! To those of MS folks who are still not getting it: if your unit has 10 members, and if everybody uses some Sharepoint site every day in a month, then - normal people would say: 'we have 10 unique users per month', but in 'Popularity Trends' o SP, MS says: 620 unique users' (because some 'smart' MS guy was too lazy to think, and other 'smart' testers and quality don't understand their job.