Mforns has uploaded a new change for review.
https://gerrit.wikimedia.org/r/281818
Change subject: Reconfigure mobile-options-last-3-months query
......................................................................
Reconfigure mobile-options-last-3-months query
After some changes in reportupdater:
1) New 'max-data-points' option, that permits to generate reports
with only the last N data points.
2) New 'execute' option, that permits reusing a query to generate
various reports.
3) Removal (simplification) of 'frequency' and 'timeboxed' options.
The mobile config file needed small adjustments for the
mobile-options-last-3-months report to continue working.
Bug: T131849
Change-Id: Iba85f07521f2cf4e2195b5aa453e2a24528d493c
---
M mobile/config.yaml
D mobile/mobile-options-last-3-months.sql
2 files changed, 3 insertions(+), 28 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/18/281818/1
diff --git a/mobile/config.yaml b/mobile/config.yaml
index 5ce44b7..f75d8f8 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -9,30 +9,22 @@
reports:
page-ui-daily:
- frequency: hours
granularity: days
- timeboxed: true
starts: 2014-12-12
watchlist-activity:
- frequency: hours
granularity: days
starts: 2014-01-02
- timeboxed: true
diff-activity:
- frequency: hours
granularity: days
starts: 2014-01-01
- timeboxed: true
main-menu-daily:
- frequency: hours
granularity: days
starts: 2014-12-12
- timeboxed: true
mobile-options:
- frequency: hours
granularity: days
starts: 2014-04-16
- timeboxed: true
mobile-options-last-3-months:
- frequency: hours
+ execute: mobile-options
granularity: days
+ max_data_points: 90
+ starts: 2016-01-01
diff --git a/mobile/mobile-options-last-3-months.sql
b/mobile/mobile-options-last-3-months.sql
deleted file mode 100644
index 14cc2a3..0000000
--- a/mobile/mobile-options-last-3-months.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-select
- date(timestamp) as Day,
- sum(if(event_beta = 'on', 1, 0)) as 'Beta opt in',
- sum(if(event_beta = 'off', 1, 0)) as 'Beta opt out',
- sum(if(event_alpha = 'on', 1, 0)) as 'Alpha opt in',
- sum(if(event_alpha = 'off', 1, 0)) as 'Alpha opt out',
- sum(if(event_images = 'on', 1, 0)) as 'Images turned on',
- sum(if(event_images = 'off', 1, 0)) as 'Images turned off'
-from
-(select timestamp, event_beta, event_images, event_alpha from
MobileOptionsTracking_8101982
- union all
-select timestamp, event_beta, event_images, 'nochange' as event_alpha from
MobileOptionsTracking_14003392)
- as motable
-where
- timestamp >= CURRENT_DATE - INTERVAL 90 DAY
-group by 1
-;
--
To view, visit https://gerrit.wikimedia.org/r/281818
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iba85f07521f2cf4e2195b5aa453e2a24528d493c
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Mforns <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
