Catrope has uploaded a new change for review.
https://gerrit.wikimedia.org/r/264700
Change subject: Add a graph tracking how many people have enabled the
cross-wiki notifications beta feature
......................................................................
Add a graph tracking how many people have enabled the cross-wiki notifications
beta feature
Change-Id: I7fea145e02cbd55bacf4c86595720ce5a2690d42
---
M ee/config.yaml
A ee/crosswiki_betafeature.sql
2 files changed, 18 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-ee-data
refs/changes/00/264700/1
diff --git a/ee/config.yaml b/ee/config.yaml
index e089e28..f9fca8c 100644
--- a/ee/config.yaml
+++ b/ee/config.yaml
@@ -4,6 +4,11 @@
port: 3306
creds_file: /a/.my.cnf.research
db: enwiki # just a default, queries already specify it
+ mediawiki:
+ host: "analytics-store.eqiad.wmnet"
+ port: 3306
+ creds_file: /a/.my.cnf.research
+ db: enwiki # just a default, queries already specify it
defaults:
db: x1
@@ -37,3 +42,10 @@
starts: 2013-09-01
explode_by:
wiki_db: enwiki, dewiki, eswiki, frwiki, hewiki, huwiki, itwiki,
nlwiki, plwiki, ptwiki, svwiki
+ crosswiki_betafeature:
+ frequency: days
+ granularity: days
+ timeboxed: true
+ starts: 2016-01-19
+ explode_by:
+ wiki_db: testwiki, test2wiki, mediawikiwiki
diff --git a/ee/crosswiki_betafeature.sql b/ee/crosswiki_betafeature.sql
new file mode 100644
index 0000000..7c417e8
--- /dev/null
+++ b/ee/crosswiki_betafeature.sql
@@ -0,0 +1,6 @@
+select date('{from_timestamp}') as date,
+ count(*) as {wiki_db}
+ from {wiki_db}.user_properties
+ where up_property='echo-cross-wiki-notifications'
+ and up_value=1;
+
--
To view, visit https://gerrit.wikimedia.org/r/264700
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I7fea145e02cbd55bacf4c86595720ce5a2690d42
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-ee-data
Gerrit-Branch: master
Gerrit-Owner: Catrope <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
