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.
|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|
|Open||None||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|
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