jenkins-bot has submitted this change and it was merged.
Change subject: Update limn graphs
......................................................................
Update limn graphs
Bug: T93690
Change-Id: I77f16666cb9cb1c0dc4fc19c26a1c314d82e9990
---
M mobile/main-menu-daily.sql
1 file changed, 25 insertions(+), 3 deletions(-)
Approvals:
Jdlrobson: Looks good to me, approved
Bmansurov: Looks good to me, but someone else must approve
jenkins-bot: Verified
diff --git a/mobile/main-menu-daily.sql b/mobile/main-menu-daily.sql
index 4cd6a2b..400a9ae 100644
--- a/mobile/main-menu-daily.sql
+++ b/mobile/main-menu-daily.sql
@@ -7,7 +7,8 @@
sum(Settings) as Settings,
sum(Profile) as Profile,
sum(Logout) as Logout,
- sum(Login) as Login
+ sum(Login) as Login,
+ sum(Collections) as Collections
FROM (
(
SELECT
@@ -19,7 +20,8 @@
sum(if(event_name = 'hamburger-settings', 1, 0)) as Settings,
sum(if(event_name = 'hamburger-profile', 1, 0)) as Profile,
sum(if(event_name = 'hamburger-logout', 1, 0)) as Logout,
- sum(if(event_name = 'hamburger-login', 1, 0)) as Login
+ sum(if(event_name = 'hamburger-login', 1, 0)) as Login,
+ 0 as Collections
FROM
MobileWebClickTracking_5929948
WHERE
@@ -37,11 +39,31 @@
sum(if(event_name = 'settings', 1, 0)) as Settings,
sum(if(event_name = 'profile', 1, 0)) as Profile,
sum(if(event_name = 'logout', 1, 0)) as Logout,
- sum(if(event_name = 'login', 1, 0)) as Login
+ sum(if(event_name = 'login', 1, 0)) as Login,
+ 0 as Collections
FROM
MobileWebMainMenuClickTracking_10703095
WHERE
timestamp >= '{from_timestamp}' AND
timestamp <= '{to_timestamp}'
)
+ UNION
+ (
+ SELECT
+ sum(if(event_name = 'home', 1, 0)) as Home,
+ sum(if(event_name = 'random', 1, 0)) as Random,
+ sum(if(event_name = 'nearby', 1, 0)) as Nearby,
+ sum(if(event_name = 'watchlist', 1, 0)) as Watchlist,
+ sum(if(event_name = 'uploads', 1, 0)) as Uploads,
+ sum(if(event_name = 'settings', 1, 0)) as Settings,
+ sum(if(event_name = 'profile', 1, 0)) as Profile,
+ sum(if(event_name = 'logout', 1, 0)) as Logout,
+ sum(if(event_name = 'login', 1, 0)) as Login,
+ sum(if(event_name = 'collections', 1, 0)) as Collections
+ FROM
+ MobileWebMainMenuClickTracking_11568715
+ WHERE
+ timestamp >= '{from_timestamp}' AND
+ timestamp <= '{to_timestamp}'
+ )
) AS MobileWebMainMenuClickTracking
--
To view, visit https://gerrit.wikimedia.org/r/199162
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I77f16666cb9cb1c0dc4fc19c26a1c314d82e9990
Gerrit-PatchSet: 5
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Jdlrobson <[email protected]>
Gerrit-Reviewer: Bmansurov <[email protected]>
Gerrit-Reviewer: Jdlrobson <[email protected]>
Gerrit-Reviewer: Milimetric <[email protected]>
Gerrit-Reviewer: Nuria <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
