JGonera has uploaded a new change for review.
https://gerrit.wikimedia.org/r/80553
Change subject: Story 1071: Add edit errors on daily edit graphs
......................................................................
Story 1071: Add edit errors on daily edit graphs
Change-Id: I0c670215b2e94c78604d7c83ad94c7994e0fa174
---
M dashboards/reportcard.json
A datasources/error-edits.json
A graphs/error-edits.json
M mobile/config.yaml
A mobile/error-edits.sql
5 files changed, 162 insertions(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/53/80553/1
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
index 9c390d9..b4bc105 100644
--- a/dashboards/reportcard.json
+++ b/dashboards/reportcard.json
@@ -9,7 +9,8 @@
"successful-edits-main",
"successful-edits-newbie",
"successful-edits-other",
- "successful-edits-unique"
+ "successful-edits-unique",
+ "error-edits"
]
},
{
diff --git a/datasources/error-edits.json b/datasources/error-edits.json
new file mode 100644
index 0000000..df14694
--- /dev/null
+++ b/datasources/error-edits.json
@@ -0,0 +1,21 @@
+{
+ "timespan": {
+ "start": "2013/02/18",
+ "step": "1d",
+ "end": "2013/03/19"
+ },
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/error-edits.csv";,
+ "format": "csv",
+ "type": "timeseries",
+ "id": "error-edits",
+ "columns": [
+ {
+ "type": "date",
+ "label": "date"
+ },
+ {
+ "type": "int",
+ "label": "Total"
+ }
+ ]
+}
diff --git a/graphs/error-edits.json b/graphs/error-edits.json
new file mode 100644
index 0000000..7e0622c
--- /dev/null
+++ b/graphs/error-edits.json
@@ -0,0 +1,115 @@
+{
+ "graph_version": "0.6.0",
+ "name": "Edits failed because of an error",
+ "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": 0,
+ "metric": {
+ "source_id": "error-edits",
+ "type": "int",
+ "source_col": 1
+ },
+ "nodeType": "line",
+ "options": {
+ "stroke": {
+ "width": 2
+ },
+ "label": "Total",
+ "noLegend": false,
+ "dateFormat": "MMM YYYY"
+ }
+ }
+ ]
+ }
+ ]
+ },
+ "id": "error-edits"
+}
diff --git a/mobile/config.yaml b/mobile/config.yaml
index a5a650c..a6454b3 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -42,6 +42,8 @@
title: Successful other namespace edits (per day)
successful-edits-unique:
title: Successful unique user edits (per day)
+ error-edits:
+ title: Edits failed because of an error (per day)
successful-logins:
title: Successful logins (per day)
successful-uploads:
diff --git a/mobile/error-edits.sql b/mobile/error-edits.sql
new file mode 100644
index 0000000..e1d85db
--- /dev/null
+++ b/mobile/error-edits.sql
@@ -0,0 +1,22 @@
+SELECT
+ Month.Date,
+ COALESCE(Web.Web, 0) AS Web
+
+-- 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 information_schema.columns, (SELECT @num:=-1) num LIMIT {{
intervals.running_average }}
+) AS Month
+LEFT JOIN (
+ SELECT
+ DATE(timestamp) AS Date,
+ SUM(1) AS Web
+
+ FROM {{ tables.edits_web }} WHERE
+ event_action = 'error' AND
+ wiki != 'testwiki'
+ GROUP BY Date
+) AS Web ON Month.Date = Web.Date;
--
To view, visit https://gerrit.wikimedia.org/r/80553
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I0c670215b2e94c78604d7c83ad94c7994e0fa174
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: JGonera <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
