[01:30:12] (PS13) Nuria: Allow filtering of data breakdowns [analytics/dashiki] - https://gerrit.wikimedia.org/r/278395 (https://phabricator.wikimedia.org/T131547) (owner: Jdlrobson) [06:17:32] (CR) Yuvipanda: [C: 2 V: 2] "Thank you for your patch :D" [analytics/quarry/web] - https://gerrit.wikimedia.org/r/283839 (https://phabricator.wikimedia.org/T117645) (owner: Zhuyifei1999) [06:27:57] Quarry, Patch-For-Review: Add 'download as wikitable' option (Quarry) - https://phabricator.wikimedia.org/T117645#2232970 (yuvipanda) Open>Resolved Thanks @zhuyifei1999 for the patch :D I've deployed it now! [06:56:34] Quarry, Labs, Labs-Infrastructure, Operations, and 3 others: Quarry should be HTTPS-only - https://phabricator.wikimedia.org/T107627#2233035 (yuvipanda) It is now! [06:56:40] Quarry, Labs, Labs-Infrastructure, Operations, and 3 others: Quarry should be HTTPS-only - https://phabricator.wikimedia.org/T107627#2233036 (yuvipanda) Open>Resolved a:yuvipanda [07:29:24] Analytics, Analytics-Kanban, Pageviews-API, RESTBase-Cassandra: Better response times on AQS (Pageview API mostly) {melc} - https://phabricator.wikimedia.org/T124314#2233038 (Nemo_bis) [08:21:12] Quarry: AnalyticsEng has a transition plan for maintenance of Internal Quarry - https://phabricator.wikimedia.org/T75143#2233055 (yuvipanda) [08:21:15] Analytics, Quarry: Build an internal Quarry instance to share data & sample queries between researchers (and other analytics users?) - https://phabricator.wikimedia.org/T75142#2233053 (yuvipanda) Open>declined Yes. [08:21:22] Quarry: AnalyticsEng has a transition plan for maintenance of Internal Quarry - https://phabricator.wikimedia.org/T75143#771374 (yuvipanda) Open>declined [08:37:18] (PS14) Yuvipanda: Database selection [analytics/quarry/web] - https://gerrit.wikimedia.org/r/266925 (https://phabricator.wikimedia.org/T76466) (owner: Alex Monk) [08:42:33] (CR) Yuvipanda: "Doing the schema change now." [analytics/quarry/web] - https://gerrit.wikimedia.org/r/266925 (https://phabricator.wikimedia.org/T76466) (owner: Alex Monk) [08:42:47] (CR) Yuvipanda: [C: 2 V: 2] Database selection [analytics/quarry/web] - https://gerrit.wikimedia.org/r/266925 (https://phabricator.wikimedia.org/T76466) (owner: Alex Monk) [08:47:37] (PS1) Yuvipanda: Revert "Database selection" [analytics/quarry/web] - https://gerrit.wikimedia.org/r/285063 [08:47:50] (CR) Yuvipanda: [C: 2 V: 2] Revert "Database selection" [analytics/quarry/web] - https://gerrit.wikimedia.org/r/285063 (owner: Yuvipanda) [09:42:59] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233073 (ezachte) Content (=countable) namespaces are collected daily via API call [1] using perl file [2] and bash file [3], and written to cs... [10:16:20] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233084 (ezachte) As for counting bytes vs chars vs words, here are some considerations. **Bytes** Surely counting bytes is easy and cheap (an... [10:28:35] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233090 (ezachte) **Regional codes and number of speakers per language.** I said indeed this was html scraped from Wikipedia, but I confused t... [10:54:25] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233120 (ezachte) **Anons** Wikistats groups editors, edits and creates by user type, registered (and logged in) user, anonymous user or bot.... [11:08:30] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233151 (ezachte) **Bots** Note that many users like puns or letter games and make up a nick with 'bot' in it just because they can. Recap on... [11:25:43] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233153 (ezachte) **Reverts** Quote: //"revert_info [can either be reverted_revision in case of sha1 equality, or if revert is present in comm... [11:29:33] Analytics-Kanban: Examine wikistats reports, make a summary of the most granular data needed that would serve all reports - https://phabricator.wikimedia.org/T131783#2233166 (ezachte) **Count of links** Counts of links are seldom mentioned anywhere. This is also susceptible to skewing as many links occur in... [16:26:41] (CR) Alex Monk: "What was wrong?" [analytics/quarry/web] - https://gerrit.wikimedia.org/r/285063 (owner: Yuvipanda) [16:27:03] Quarry: Add database selector - https://phabricator.wikimedia.org/T76466#2233559 (Krenair) a:Krenair [16:27:51] Analytics, Quarry: it would be useful to run the same Quarry query conveniently in several database - https://phabricator.wikimedia.org/T95582#1195035 (Krenair) Probably going to be done in {T76466} [20:00:45] (CR) Ori.livneh: [C: 2 V: 2] statsv: Start at offset LATEST instead of the default EARLIEST [analytics/statsv] - https://gerrit.wikimedia.org/r/284836 (https://phabricator.wikimedia.org/T132770) (owner: Krinkle)