OpenConext / OpenConext-statistics

Statistics
Apache License 2.0
0 stars 1 forks source link

Weekly stats duplicated for entity when week crosses over month #244

Closed phavekes closed 2 days ago

phavekes commented 2 days ago

This issue is imported from pivotal - Originaly created at Sep 16, 2019 by Okke Harsta

phavekes commented 2 days ago

When a week crosses over a week then the numbers are duplicated for entities. (Okke Harsta - Sep 16, 2019)

phavekes commented 2 days ago

Fixed by not grouping by year, quarter and month in the CQ\'s for unique week data. Added endpoint to kickoff the migration:

curl -u sysadmin:XXX -X PUT "https://stats.test2.surfconext.nl/api/stats/admin/reinitialize_unique_week_cq"

(Okke Harsta - Sep 17, 2019)

phavekes commented 2 days ago

Migration ran fine in production, no more strange week uniques :) (Bart Geesink - Oct 29, 2019)