Gergő Tisza has uploaded a new change for review. https://gerrit.wikimedia.org/r/160785
Change subject: Add relative timeseries ...................................................................... Add relative timeseries Add a relative timeline which looks like the absolute one but shows per-step survival rates and makes it easier to glimpse trends. Rename the old "relative" to "overview". Change-Id: Ia28716e83fbdb5588be788c7ea68ea3db66ad02f Mingle: https://wikimedia.mingle.thoughtworks.com/projects/multimedia/cards/862 --- M dashboards/uw.json A datasources/uw_funnel_overview.json M datasources/uw_funnel_relative.json A graphs/uw_funnel_overview.json M graphs/uw_funnel_relative.json 5 files changed, 150 insertions(+), 17 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia/config refs/changes/85/160785/1 diff --git a/dashboards/uw.json b/dashboards/uw.json index eec8ba9..bd26483 100644 --- a/dashboards/uw.json +++ b/dashboards/uw.json @@ -6,6 +6,7 @@ { "name": "Funnel", "graph_ids": [ + "uw_funnel_overview", "uw_funnel_absolute", "uw_funnel_relative" ] diff --git a/datasources/uw_funnel_overview.json b/datasources/uw_funnel_overview.json new file mode 100644 index 0000000..d329945 --- /dev/null +++ b/datasources/uw_funnel_overview.json @@ -0,0 +1,26 @@ +{ + "id": "uw_funnel_overview", + "slug": "uw_funnel_overview", + "format": "tsv", + "type": "series", + "url": "http://stat1001.wikimedia.org/public-datasets/all/multimedia/upload-wizard-funnel-overview.tsv";, + "name": "Funnel", + "shortName": "uw_funnel_overview", + "columns": [ + { + "id": "step", + "label": "Step", + "type": "String" + }, + { + "id": "relative", + "label": "Relative (ratio of users who survived the last step)", + "type": "Number" + }, + { + "id": "absolute", + "label": "Absolute (number of users surviving until this step)", + "type": "Number" + } + ] +} diff --git a/datasources/uw_funnel_relative.json b/datasources/uw_funnel_relative.json index ffa90d3..e9155dd 100644 --- a/datasources/uw_funnel_relative.json +++ b/datasources/uw_funnel_relative.json @@ -8,18 +8,28 @@ "shortName": "uw_funnel_relative", "columns": [ { - "id": "step", - "label": "Step", - "type": "String" + "id": "datestring", + "label": "datestring", + "type": "Date" }, { - "id": "relative", - "label": "Relative (ratio of users who survived the last step)", + "id": "tutorial", + "label": "Tutorial survivors (ratio of users surviving from tutorial to file step)", "type": "Number" }, { - "id": "absolute", - "label": "Absolute (number of users surviving until this step)", + "id": "file", + "label": "File survivors (ratio of users surviving from file to deeds step)", + "type": "Number" + }, + { + "id": "deeds", + "label": "Deeds survivors (ratio of users surviving from deeds to details step)", + "type": "Number" + }, + { + "id": "details", + "label": "Details survivors (ratio of users surviving from details to thanks step)", "type": "Number" } ] diff --git a/graphs/uw_funnel_overview.json b/graphs/uw_funnel_overview.json new file mode 100644 index 0000000..0ddf3b4 --- /dev/null +++ b/graphs/uw_funnel_overview.json @@ -0,0 +1,55 @@ +{ + "graph_version": "0.6.0", + "id": "uw_funnel_overview", + "desc": "<a href=\"https://en.wikipedia.org/wiki/Funnel_chart\";>Funnel analysis for Upload Wizard</a>. The data displayed is the average over the last 30 days. The value for each step is the percentage of users surviving this step to the next one.", + "name": "Funnel overview (relative, average over last 30 days)", + "slug": "uw_funnel_overview", + "root": { + "nodeType": "canvas", + "width": "auto", + "height": 500, + "children": [ + { + "nodeType": "axis", + "options": { + "orient": "bottom", + "dimension": "x", + "label": "step" + } + }, + { + "nodeType": "axis", + "options": { + "orient": "left", + "dimension": "y" + } + }, + { + "nodeType": "grid", + "options": {"dimension": "y"} + }, + { + "nodeType": "legend", + "options": { + "label" : "Legend" + } + }, + { + "nodeType": "bar-group", + "children": [ + { + "nodeType": "bar", + "metric": { + "source_id": "uw_funnel_overview", + "source_col": "relative", + "type": "Number" + }, + "options": { + "label": "Fraction of users surviving this step" + } + } + ] + } + ] + } +} diff --git a/graphs/uw_funnel_relative.json b/graphs/uw_funnel_relative.json index 32ba620..dc1a6ec 100644 --- a/graphs/uw_funnel_relative.json +++ b/graphs/uw_funnel_relative.json @@ -1,8 +1,8 @@ { "graph_version": "0.6.0", "id": "uw_funnel_relative", - "desc": "<a href=\"https://en.wikipedia.org/wiki/Funnel_chart\";>Funnel analysis for Upload Wizard</a>. The data displayed is the average over the last 30 days. The value for each step is the percentage of users surviving this step to the next one.", - "name": "Funnel analysis (relative, average over last 30 days)", + "desc": "<a href=\"https://en.wikipedia.org/wiki/Funnel_chart\";>Funnel analysis for Upload Wizard</a>. Displays the daily survival rate of each step over the last 30 days.", + "name": "Funnel analysis (relative over time)", "slug": "uw_funnel_relative", "root": { "nodeType": "canvas", @@ -10,19 +10,26 @@ "height": 500, "children": [ { + "nodeType": "zoom-brush" + }, + { "nodeType": "axis", "options": { "orient": "bottom", - "dimension": "x", - "label": "step" + "dimension": "x" } }, { "nodeType": "axis", "options": { "orient": "left", - "dimension": "y" + "dimension": "y", + "label": "total count" } + }, + { + "nodeType": "grid", + "options": {"dimension": "x"} }, { "nodeType": "grid", @@ -31,21 +38,55 @@ { "nodeType": "legend", "options": { - "label" : "Legend" + "label" : "Legend", + "dateFormat" : "DD MMM YYYY" } }, { - "nodeType": "bar-group", + "nodeType": "line-group", "children": [ { - "nodeType": "bar", + "nodeType": "line", "metric": { "source_id": "uw_funnel_relative", - "source_col": "relative", + "source_col": "tutorial", "type": "Number" }, "options": { - "label": "Fraction of users surviving this step" + "label": "tutorial" + } + }, + { + "nodeType": "line", + "metric": { + "source_id": "uw_funnel_relative", + "source_col": "file", + "type": "Number" + }, + "options": { + "label": "file" + } + }, + { + "nodeType": "line", + "metric": { + "source_id": "uw_funnel_relative", + "source_col": "deeds", + "type": "Number" + }, + "options": { + "label": "deeds" + } + }, + { + "nodeType": "line", + "metric": { + "source_id": "uw_funnel_relative", + "source_col": "details", + "type": "Number" + }, + "options": { + "label": "details" } } ] -- To view, visit https://gerrit.wikimedia.org/r/160785 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia28716e83fbdb5588be788c7ea68ea3db66ad02f Gerrit-PatchSet: 1 Gerrit-Project: analytics/multimedia/config Gerrit-Branch: master Gerrit-Owner: Gergő Tisza <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
