Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Data aggregation #194

Open
patrickrobrecht opened this issue Dec 12, 2020 · 0 comments · May be fixed by #234
Open

Data aggregation #194

patrickrobrecht opened this issue Dec 12, 2020 · 0 comments · May be fixed by #234
Assignees
@stklcode
Labels
Cloudfest enhancement has patch Performance CF
Milestone
2.0.0

Comments

@patrickrobrecht
Copy link
Member

Multiple rows with the same date, target and referrer can be aggregated with an additional column count.

  • Database migration (add column count, migrate existing data)
  • In the queries count(*) needs to be replaced with SUM(count).
  • When adding a new row, check whether a row with that date, target and referrer exists already. If it exists, increase count, otherwise create it with count = 1.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stklcode stklcode

Labels
Cloudfest enhancement has patch Performance CF
Projects
None yet
Milestone
2.0.0
Development

Successfully merging a pull request may close this issue.

introduce data aggregation (#194) pluginkollektiv/statify
4 participants
@krafit @florianbrinkmann @patrickrobrecht @stklcode