Jdlrobson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/248990
Change subject: Bump MobileOptions revision
......................................................................
Bump MobileOptions revision
Discard old data (has been preserved in ticket)
Bug: T115129
Change-Id: I12d66b2efbce33964802daa3f56657153c18c6e5
---
M mobile/mobile-options-last-3-months.sql
M mobile/mobile-options.sql
2 files changed, 1 insertion(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/90/248990/1
diff --git a/mobile/mobile-options-last-3-months.sql
b/mobile/mobile-options-last-3-months.sql
index 1df1613..e30e30b 100644
--- a/mobile/mobile-options-last-3-months.sql
+++ b/mobile/mobile-options-last-3-months.sql
@@ -7,7 +7,7 @@
sum(if(event_images = 'on', 1, 0)) as 'Images turned on',
sum(if(event_images = 'off', 1, 0)) as 'Images turned off'
from
- MobileOptionsTracking_8101982
+ MobileOptionsTracking_14003392
where
timestamp >= CURRENT_DATE - INTERVAL 90 DAY
group by 1
diff --git a/mobile/mobile-options.sql b/mobile/mobile-options.sql
index 320e80e..cc8f992 100644
--- a/mobile/mobile-options.sql
+++ b/mobile/mobile-options.sql
@@ -2,8 +2,6 @@
date('{from_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
--
To view, visit https://gerrit.wikimedia.org/r/248990
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I12d66b2efbce33964802daa3f56657153c18c6e5
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Jdlrobson <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
