Jdlrobson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/199162
Change subject: Update limn graphs (untested)
......................................................................
Update limn graphs (untested)
If someone can verify this works I'd be most appreciative.
Bug: T93690
Change-Id: I77f16666cb9cb1c0dc4fc19c26a1c314d82e9990
---
M mobile/main-menu-daily.sql
1 file changed, 21 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/62/199162/1
diff --git a/mobile/main-menu-daily.sql b/mobile/main-menu-daily.sql
index 4cd6a2b..eba06a6 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
@@ -44,4 +45,23 @@
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 Login
+ 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: newchange
Gerrit-Change-Id: I77f16666cb9cb1c0dc4fc19c26a1c314d82e9990
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
