Yuvipanda has uploaded a new change for review.
https://gerrit.wikimedia.org/r/60011
Change subject: Add graph showing % of images that were not categorized
......................................................................
Add graph showing % of images that were not categorized
Change-Id: I0ebff06527f149db7291d6efa2f6083b481f3bb8
---
M dashboards/reportcard.json
A datasources/no-cats.json
A graphs/no-cats.json
M mobile/config.yaml
A mobile/no-cats.sql
5 files changed, 177 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/11/60011/1
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
index 6b1a750..5726dd3 100644
--- a/dashboards/reportcard.json
+++ b/dashboards/reportcard.json
@@ -9,9 +9,10 @@
"unique-uploaders",
"30-day-uploads",
"successful-uploads",
- "share-attempts",
"successful-logins",
- "error-uploads"
+ "error-uploads",
+ "no-cats",
+ "share-attempts"
]
},
{
diff --git a/datasources/no-cats.json b/datasources/no-cats.json
new file mode 100644
index 0000000..3e09cee
--- /dev/null
+++ b/datasources/no-cats.json
@@ -0,0 +1,26 @@
+{
+ "name": "% of Uploads without categories",
+ "timespan": {
+ "start": "2013/02/18",
+ "step": "1d",
+ "end": "2013/03/19"
+ },
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/no-cats.csv";,
+ "notes": "",
+ "format": "csv",
+ "slug": null,
+ "shortName": "no-cats",
+ "type": "timeseries",
+ "id": "no-cats",
+ "columns": [
+ {
+ "type": "date",
+ "label": "date"
+ },
+ {
+ "type": "int",
+ "label": "Android"
+ }
+ ],
+ "desc": ""
+}
diff --git a/graphs/no-cats.json b/graphs/no-cats.json
new file mode 100644
index 0000000..ee01e7e
--- /dev/null
+++ b/graphs/no-cats.json
@@ -0,0 +1,119 @@
+{
+ "graph_version": "0.6.0",
+ "name": "Percentage of Files uploaded with no categories",
+ "notes": "",
+ "slug": "no-cats",
+ "shortName": "",
+ "root": {
+ "scaling": "linear",
+ "nodeType": "canvas",
+ "minWidth": 750,
+ "minHeight": 500,
+ "height": 500,
+ "disabled": false,
+ "width": "auto",
+ "children": [
+ {
+ "disabled": false,
+ "nodeType": "axis",
+ "options": {
+ "tickFormat": "MMM YY",
+ "dimension": "x",
+ "orient": "bottom"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "axis",
+ "options": {
+ "tickFormat": "MMM YY",
+ "dimension": "y",
+ "orient": "left"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "grid",
+ "options": {
+ "ticks": 10,
+ "dimension": "x"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "grid",
+ "options": {
+ "ticks": 10,
+ "dimension": "y"
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "zoom-brush",
+ "options": {
+ "allowY": true,
+ "allowX": true
+ }
+ },
+ {
+ "nodeType": "callout",
+ "target": "latest",
+ "disabled": false,
+ "steps": [
+ "1y",
+ "1M"
+ ],
+ "metricRef": 0,
+ "options": {
+ "deltaPercent": true,
+ "dateFormat": "MMM YYYY",
+ "colorDelta": true
+ }
+ },
+ {
+ "disabled": false,
+ "nodeType": "legend",
+ "options": {
+ "valueFormat": ",.2s",
+ "dateFormat": "MMM YYYY"
+ },
+ "label": "Aug 2012"
+ },
+ {
+ "disabled": false,
+ "nodeType": "line-group",
+ "options": {
+ "palette": "wmf_projects",
+ "scale": "log",
+ "stroke": {
+ "opacity": 1,
+ "width": 2
+ },
+ "dateFormat": "MMM YYYY"
+ },
+ "children": [
+ {
+ "disabled": false,
+ "index": 1,
+ "metric": {
+ "source_id": "no-cats",
+ "type": "int",
+ "source_col": 2
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Android",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "id": "no-cats",
+ "desc": ""
+}
diff --git a/mobile/config.yaml b/mobile/config.yaml
index dc419d8..e61f167 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -15,6 +15,7 @@
share_attempts: MobileAppShareAttempts_5346170
upload_web: MobileWebUploads_5281063
navigation_timing: NavigationTiming_5336845
+ cat_attempts: MobileAppCategorizationAttempts_5359208 # meow!
intervals:
running_average: 30
output:
@@ -40,6 +41,8 @@
title: Mobile Uploads vs Commons Edit count
alltime-numbers:
title: All time numbers
+ no-cats: # Only puppies
+ title: Percentage of files with a category added
performance-rendering:
title: Rendering time (ms)
diff --git a/mobile/no-cats.sql b/mobile/no-cats.sql
new file mode 100644
index 0000000..c542964
--- /dev/null
+++ b/mobile/no-cats.sql
@@ -0,0 +1,26 @@
+SELECT
+ Date,
+ (
+ (SELECT SUM(`event_files-count`) FROM {{ tables.cat_attempts }} WHERE
+ event_platform LIKE 'Android%' AND
+ `event_categories-count` = 0 AND
+ wiki = 'commonswiki' AND
+ DATE(timestamp) < Date AND
+ (timestamp + INTERVAL 0 DAY) > (Date - INTERVAL {{
intervals.running_average }} DAY)
+ ) /
+ (SELECT SUM(`event_files-count`) FROM {{ tables.cat_attempts }} WHERE
+ event_platform LIKE 'Android%' AND
+ wiki = 'commonswiki' AND
+ DATE(timestamp) < Date AND
+ (timestamp + INTERVAL 0 DAY) > (Date - INTERVAL {{
intervals.running_average }} DAY)
+ )
+ ) AS Android
+
+-- http://stackoverflow.com/a/6871220/365238
+FROM (
+ SELECT DATE_FORMAT(
+ ADDDATE(CURDATE() - INTERVAL {{ intervals.running_average }} - 1 DAY,
@num:=@num+1),
+ '%Y-%m-%d'
+ ) AS Date
+ FROM {{ tables.upload_attempts }}, (SELECT @num:=-1) num LIMIT {{
intervals.running_average }}
+) AS Month;
--
To view, visit https://gerrit.wikimedia.org/r/60011
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I0ebff06527f149db7291d6efa2f6083b481f3bb8
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Yuvipanda <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
