Yuvipanda has submitted this change and it was merged.
Change subject: Show graph of first time edits
......................................................................
Show graph of first time edits
The all graph is actually useless as it can be worked out from the
main namespace and other graphs
THIS is much more interesting
Change-Id: I9c9ee5431903bd0350834894ceef6e0b03675b7c
---
M dashboards/reportcard.json
R datasources/successful-edits-newbie.json
R graphs/successful-edits-newbie.json
M mobile/config.yaml
R mobile/successful-edits-newbie.sql
5 files changed, 9 insertions(+), 8 deletions(-)
Approvals:
Yuvipanda: Verified; Looks good to me, approved
diff --git a/dashboards/reportcard.json b/dashboards/reportcard.json
index 9417268..9c390d9 100644
--- a/dashboards/reportcard.json
+++ b/dashboards/reportcard.json
@@ -7,7 +7,7 @@
"name": "Edits daily",
"graph_ids": [
"successful-edits-main",
- "successful-edits",
+ "successful-edits-newbie",
"successful-edits-other",
"successful-edits-unique"
]
diff --git a/datasources/successful-edits.json
b/datasources/successful-edits-newbie.json
similarity index 83%
rename from datasources/successful-edits.json
rename to datasources/successful-edits-newbie.json
index 51478d0..0a8cd0d 100644
--- a/datasources/successful-edits.json
+++ b/datasources/successful-edits-newbie.json
@@ -4,10 +4,10 @@
"step": "1d",
"end": "2013/03/19"
},
- "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/successful-edits.csv";,
+ "url":
"http://stat1001.wikimedia.org/limn-public-data/mobile/datafiles/successful-edits-newbie.csv";,
"format": "csv",
"type": "timeseries",
- "id": "successful-edits",
+ "id": "successful-edits-newbie",
"columns": [
{
"type": "date",
diff --git a/graphs/successful-edits.json b/graphs/successful-edits-newbie.json
similarity index 94%
rename from graphs/successful-edits.json
rename to graphs/successful-edits-newbie.json
index 59c55ec..bae4f2a 100644
--- a/graphs/successful-edits.json
+++ b/graphs/successful-edits-newbie.json
@@ -1,6 +1,6 @@
{
"graph_version": "0.6.0",
- "name": "Successful Edits (All)",
+ "name": "Successful first edits on mobile",
"root": {
"scaling": "linear",
"nodeType": "canvas",
@@ -93,7 +93,7 @@
"disabled": false,
"index": 0,
"metric": {
- "source_id": "successful-edits",
+ "source_id": "successful-edits-newbie",
"type": "int",
"source_col": 1
},
@@ -111,6 +111,6 @@
}
]
},
- "id": "successful-edits",
+ "id": "successful-edits-newbie",
"desc": ""
}
diff --git a/mobile/config.yaml b/mobile/config.yaml
index 729c00a..a5a650c 100644
--- a/mobile/config.yaml
+++ b/mobile/config.yaml
@@ -34,8 +34,8 @@
title: Uploads cancelled by user (per day)
error-uploads:
title: Uploads failed because of an upload error (per day)
- successful-edits:
- title: Successful edits (per day)
+ successful-edits-newbie:
+ title: Successful edits by first time users (per day)
successful-edits-main:
title: Successful Main namespace edits (per day)
successful-edits-other:
diff --git a/mobile/successful-edits.sql b/mobile/successful-edits-newbie.sql
similarity index 93%
rename from mobile/successful-edits.sql
rename to mobile/successful-edits-newbie.sql
index 61ef856..488fab4 100644
--- a/mobile/successful-edits.sql
+++ b/mobile/successful-edits-newbie.sql
@@ -17,6 +17,7 @@
FROM {{ tables.edits_web }} WHERE
event_action = 'success' AND
+ event_userEditCount = 0 AND
wiki != 'testwiki'
GROUP BY Date
) AS Web ON Month.Date = Web.Date;
--
To view, visit https://gerrit.wikimedia.org/r/77278
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I9c9ee5431903bd0350834894ceef6e0b03675b7c
Gerrit-PatchSet: 2
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Jdlrobson <[email protected]>
Gerrit-Reviewer: JGonera <[email protected]>
Gerrit-Reviewer: Yuvipanda <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
