Milimetric has uploaded a new change for review.
https://gerrit.wikimedia.org/r/183739
Change subject: Set up initial example query and config
......................................................................
Set up initial example query and config
Change-Id: Ifbc0c6242beb582bfee1eb5bc6525f9dccd401cf
---
A dashboards/reportcard.json
A language/config.yaml
A language/content_translation_beta.sql
3 files changed, 53 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-language-data
refs/changes/39/183739/1
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
new file mode 100644
index 0000000..4d7d20d
--- /dev/null
+++ b/dashboards/reportcard.json
@@ -0,0 +1,13 @@
+{
+ "id" : "reportcard",
+ "headline" : "Language",
+ "subhead" : "",
+ "tabs": [
+ {
+ "name": "Beta Enables",
+ "graph_ids": [
+
"http://datasets.wikimedia.org/limn-public-data/language/datafiles/content_translation_beta.csv";
+ ]
+ }
+ ]
+}
diff --git a/language/config.yaml b/language/config.yaml
new file mode 100644
index 0000000..db977e0
--- /dev/null
+++ b/language/config.yaml
@@ -0,0 +1,21 @@
+databases:
+ el:
+ host: "analytics-store.eqiad.wmnet"
+ port: 3306
+ creds_file: /a/.my.cnf.research
+ db: log
+# for convenience, define unions of different event logging schemas here:
+tables:
+intervals:
+ running_average: 30
+output:
+ path: /a/limn-public-data/language/datafiles
+defaults:
+ db: el
+# the key in the graph section is the name of the sql file and generated file
+graphs:
+ content_translation_beta:
+ title: 'People enabling Content Translation'
+ frequency: hourly
+ timeboxed: true
+ starts: 2015-01-07
diff --git a/language/content_translation_beta.sql
b/language/content_translation_beta.sql
new file mode 100644
index 0000000..16f877a
--- /dev/null
+++ b/language/content_translation_beta.sql
@@ -0,0 +1,19 @@
+ select *
+ from (select count(*) as enwiki from enwiki.user_properties where
up_property = 'cx') en
+ left join
+ (select count(*) as cawiki from cawiki.user_properties where
up_property = 'cx') ca on 1=1
+ left join
+ (select count(*) as eswiki from eswiki.user_properties where
up_property = 'cx') es on 1=1
+ left join
+ (select count(*) as ptwiki from ptwiki.user_properties where
up_property = 'cx') pt on 1=1
+ left join
+ (select count(*) as dawiki from dawiki.user_properties where
up_property = 'cx') da on 1=1
+ left join
+ (select count(*) as eowiki from eowiki.user_properties where
up_property = 'cx') eo on 1=1
+ left join
+ (select count(*) as idwiki from idwiki.user_properties where
up_property = 'cx') id on 1=1
+ left join
+ (select count(*) as mswiki from mswiki.user_properties where
up_property = 'cx') ms on 1=1
+ left join
+ (select count(*) as sawiki from sawiki.user_properties where
up_property = 'cx') sa on 1=1
+;
--
To view, visit https://gerrit.wikimedia.org/r/183739
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifbc0c6242beb582bfee1eb5bc6525f9dccd401cf
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-language-data
Gerrit-Branch: master
Gerrit-Owner: Milimetric <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
