jenkins-bot has submitted this change and it was merged.
Change subject: Fix app user block report
......................................................................
Fix app user block report
Didn't need the date as the first column
Change-Id: I6cf92fa2d0592f23d6c7baa81b14a5074b188b39
---
M mobile/app-user-blocks-en.sql
1 file changed, 1 insertion(+), 2 deletions(-)
Approvals:
BearND: Looks good to me, approved
jenkins-bot: Verified
diff --git a/mobile/app-user-blocks-en.sql b/mobile/app-user-blocks-en.sql
index 7d9a865..8735847 100644
--- a/mobile/app-user-blocks-en.sql
+++ b/mobile/app-user-blocks-en.sql
@@ -2,8 +2,7 @@
-- For this report:
-- you are considered an 'app user' if you've created the account on the
Android or iOS native app
-SELECT DATE( ipb_timestamp) AS Date,
- COUNT( 1 ) AS NumBlocks
+SELECT COUNT( 1 ) AS NumBlocks
FROM
(
SELECT ipb_user,
--
To view, visit https://gerrit.wikimedia.org/r/157304
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I6cf92fa2d0592f23d6c7baa81b14a5074b188b39
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: BearND <bsitzm...@wikimedia.org>
Gerrit-Reviewer: BearND <bsitzm...@wikimedia.org>
Gerrit-Reviewer: JGonera <jgon...@wikimedia.org>
Gerrit-Reviewer: Milimetric <dandree...@wikimedia.org>
Gerrit-Reviewer: Nuria <nu...@wikimedia.org>
Gerrit-Reviewer: Springle <sprin...@wikimedia.org>
Gerrit-Reviewer: Yuvipanda <yuvipa...@gmail.com>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
