Mforns has uploaded a new change for review.
https://gerrit.wikimedia.org/r/197318
Change subject: Add config to run funnel_failure_rates_by_type
......................................................................
Add config to run funnel_failure_rates_by_type
Bug: T89251
Change-Id: Id7fd6b8ac2c867ecbb450c685dc96be253f7b83c
---
M edit/config.yaml
M edit/funnel_failure_rates_by_type.sql
2 files changed, 11 insertions(+), 12 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-edit-data
refs/changes/18/197318/1
diff --git a/edit/config.yaml b/edit/config.yaml
index 6c1bd45..8cefc1a 100644
--- a/edit/config.yaml
+++ b/edit/config.yaml
@@ -48,3 +48,9 @@
# Successful saves against Loads rate
title: "How many editor loads end up with saves? - Comparative for
select Wikipedias"
frequency: hourly
+
+reportupdater-reports:
+ funnel_failure_rates_by_type:
+ frequency: hourly
+ timeboxed: true
+ starts: 2015-01-01
diff --git a/edit/funnel_failure_rates_by_type.sql
b/edit/funnel_failure_rates_by_type.sql
index 3c0395a..e0406fa 100644
--- a/edit/funnel_failure_rates_by_type.sql
+++ b/edit/funnel_failure_rates_by_type.sql
@@ -1,11 +1,3 @@
-set @from_time = '{from_timestamp}';
-set @to_time = '{to_timestamp}';
-set @wiki = '{wiki}';
-
-set @from_time = '20141203000000';
-set @to_time = '20150201000000';
-set @wiki = null;
-
select day,
sum(if(actions like '%saveAttempt%saveFailure%', repeated, 0)) /
sum(if(actions like '%saveAttempt%', repeated, 0)) as 'total',
@@ -36,7 +28,7 @@
wiki,
group_concat(event_action order by timestamp,
action_order.ord separator '-') as actions,
group_concat(`event_action.saveFailure.type` order by
timestamp separator '-') as failures
- from staging.milimetric_edit
+ from Edit_10676603 -- staging.milimetric_edit
inner join
(select 'init' as action, 0 as ord
union all
@@ -51,10 +43,11 @@
select 'saveSuccess' as action, 5 as ord
union all
select 'abort' as action, 6 as ord
- ) action_order on action =
staging.milimetric_edit.event_action
+ ) action_order on action = Edit_10676603.event_action
-- staging.milimetric_edit.event_action
where event_editor = 'visualeditor'
- and timestamp between @from_time and @to_time
- and (@wiki is null or wiki = @wiki)
+ and timestamp >= {from_timestamp}
+ and timestamp < {to_timestamp}
+ -- and (@wiki is null or wiki = @wiki)
group by clientIp, event_editingSessionId
# this purposefully ignores sessions that start before
"from_timestamp",
# as well as some other sessions that legitimately do not
have an "init"
--
To view, visit https://gerrit.wikimedia.org/r/197318
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Id7fd6b8ac2c867ecbb450c685dc96be253f7b83c
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-edit-data
Gerrit-Branch: master
Gerrit-Owner: Mforns <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
