Intervals (10000-100000) pageviews work well for small wikis, once we are into the large wikis they become meaningless and we should look into how to best represent that data for say, pageviews of enwiki in belgium.
Description
Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | None | T120037 Vital Signs: Please provide an "all languages" de-duplicated stream for the Community/Content groups of metrics | |||
Resolved | None | T120036 Vital Signs: Please make the data for enwiki and other big wikis less sad, and not just be missing for most days | |||
Resolved | odimitrijevic | T130256 Wikistats 2.0. | |||
Resolved | None | T90759 Create Daily & Monthly pageview dump with country data and Visualize on UI | |||
Resolved | • fdans | T188928 Intervals/buckets for data arround pageviews per country in wikistats maps |
Event Timeline
@Nuria
I'm considering this task for the GSoC, but I don't completely understand the title.
Is is about adding a time interval selector (like a slider) for the map chart?
@Nuria I'd like to look into this. Can you please elaborate a bit more? A pseudo code of what we have now and what is expected would be great :]
For whomever works on this, we have two possible solutions, they can think of a third one and we generally trust them to choose well:
- keep one field for pageviews_total and populate it with ranges for lower numbers and exact numbers for higher numbers
- add another field, pageviews_range. For lower numbers, pageviews_total is null and pageviews_range is populated. For higher numbers it's the opposite
The new numeric value should be an int that represents the ceiling "to the thousandth" of the original number (ceil(x/1000)*1000), as long as that number is bigger than 99. Otherwise the number doesn't get reported. They way we'll be doing this is:
- Add a new int column that stores the new value.
- We add the column to the aqs frontend
- Switch the frontend so that it uses the new value.
- Adapt the UI
- Backfill
Change 440136 had a related patch set uploaded (by Fdans; owner: Fdans):
[analytics/aqs@master] Add glue code to turn "ceiled" pageview values into intervals
Change 440145 had a related patch set uploaded (by Fdans; owner: Fdans):
[analytics/refinery@master] Modify pageview per country query to load numbers instead of intervals
Change 440136 merged by Fdans:
[analytics/aqs@master] Add glue code to turn "ceiled" pageview values into intervals
Change 440145 merged by Joal:
[analytics/refinery@master] Modify pageview per country query to load numbers instead of intervals
moving back to in progress as there's still the patch for the UI pending, thank you @JAllemandou :)