Bearloga has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/363371 )
Change subject: Fix TSS2 revision number ...................................................................... Fix TSS2 revision number Change-Id: I9dea07bbb615ceb4a42ad8e74f19b651e1d440da --- M CHANGELOG.md M modules/metrics/search/desktop_event_counts.R M modules/metrics/search/load_times.R M modules/metrics/search/paulscore_approximations.R M modules/metrics/search/sample_page_visit_ld.R M modules/metrics/search/search_threshold_pass_rate.R 6 files changed, 8 insertions(+), 5 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/wikimedia/discovery/golden refs/changes/71/363371/1 diff --git a/CHANGELOG.md b/CHANGELOG.md index d429ae3..9de2244 100644 --- a/CHANGELOG.md +++ b/CHANGELOG.md @@ -1,6 +1,9 @@ # Change Log (Patch Notes) All notable changes to this project will be documented in this file. +## 2017/07/05 +- Switched TSS2 from Revision 16270835 to 16909631 (due to [change 360851](https://gerrit.wikimedia.org/r/#/c/360851/)) + ## 2017/05/31 - Changed where datasets are located - Updated public README diff --git a/modules/metrics/search/desktop_event_counts.R b/modules/metrics/search/desktop_event_counts.R index 64188b0..699b231 100644 --- a/modules/metrics/search/desktop_event_counts.R +++ b/modules/metrics/search/desktop_event_counts.R @@ -27,7 +27,7 @@ event_pageViewId AS page_id, wiki, event_action AS action -FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", "16270835"), " +FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", dplyr::if_else(as.Date(opt$date) < "2017-06-29", "16270835", "16909631")), " WHERE ", date_clause, " AND event_action IN('searchResultPage', 'click') AND (event_subTest IS NULL OR event_subTest IN ('null', 'baseline')) diff --git a/modules/metrics/search/load_times.R b/modules/metrics/search/load_times.R index 9d86954..d6fd547 100644 --- a/modules/metrics/search/load_times.R +++ b/modules/metrics/search/load_times.R @@ -44,7 +44,7 @@ event_uniqueId AS event_id, CASE WHEN event_msToDisplayResults <= 0 THEN NULL ELSE event_msToDisplayResults END AS load_time -FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", "16270835"), " +FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", dplyr::if_else(as.Date(opt$date) < "2017-06-29", "16270835", "16909631")), " WHERE ", date_clause, " AND event_action = 'searchResultPage' AND (event_subTest IS NULL OR event_subTest IN ('null', 'baseline')) diff --git a/modules/metrics/search/paulscore_approximations.R b/modules/metrics/search/paulscore_approximations.R index 9e01107..b01f799 100644 --- a/modules/metrics/search/paulscore_approximations.R +++ b/modules/metrics/search/paulscore_approximations.R @@ -33,7 +33,7 @@ SUM(IF(event_action = 'click', POW(0.7, event_position), 0)) / SUM(IF(event_action = 'searchResultPage', 1, 0)) AS pow_7, SUM(IF(event_action = 'click', POW(0.8, event_position), 0)) / SUM(IF(event_action = 'searchResultPage', 1, 0)) AS pow_8, SUM(IF(event_action = 'click', POW(0.9, event_position), 0)) / SUM(IF(event_action = 'searchResultPage', 1, 0)) AS pow_9 -FROM TestSearchSatisfaction2_16270835 +FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", dplyr::if_else(as.Date(opt$date) < "2017-06-29", "16270835", "16909631")), " WHERE ", date_clause, " AND event_action IN ('searchResultPage', 'click') AND IF(event_source = 'autocomplete', event_inputLocation = 'header', TRUE) diff --git a/modules/metrics/search/sample_page_visit_ld.R b/modules/metrics/search/sample_page_visit_ld.R index ad1caea..e044830 100644 --- a/modules/metrics/search/sample_page_visit_ld.R +++ b/modules/metrics/search/sample_page_visit_ld.R @@ -24,7 +24,7 @@ event_pageViewId AS page_id, event_action AS action, event_checkin AS checkin -FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", "16270835"), " +FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", dplyr::if_else(as.Date(opt$date) < "2017-06-29", "16270835", "16909631")), " WHERE ", date_clause, " AND event_action IN('searchResultPage','visitPage', 'checkin') AND (event_subTest IS NULL OR event_subTest IN ('null', 'baseline')) diff --git a/modules/metrics/search/search_threshold_pass_rate.R b/modules/metrics/search/search_threshold_pass_rate.R index c15da03..c7ecb2d 100644 --- a/modules/metrics/search/search_threshold_pass_rate.R +++ b/modules/metrics/search/search_threshold_pass_rate.R @@ -26,7 +26,7 @@ event_searchSessionId AS session_id, wiki, event_action AS action -FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", "16270835"), " +FROM TestSearchSatisfaction2_", dplyr::if_else(as.Date(opt$date) < "2017-02-10", "15922352", dplyr::if_else(as.Date(opt$date) < "2017-06-29", "16270835", "16909631")), " WHERE ", date_clause, " AND event_action IN('searchResultPage', 'visitPage', 'checkin', 'click') AND (event_subTest IS NULL OR event_subTest IN ('null', 'baseline')) -- To view, visit https://gerrit.wikimedia.org/r/363371 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I9dea07bbb615ceb4a42ad8e74f19b651e1d440da Gerrit-PatchSet: 1 Gerrit-Project: wikimedia/discovery/golden Gerrit-Branch: master Gerrit-Owner: Bearloga <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
