Gergő Tisza has uploaded a new change for review.
https://gerrit.wikimedia.org/r/186089
Change subject: Take sampling into account for NavigationTiming
......................................................................
Take sampling into account for NavigationTiming
Change-Id: Id60d8b270c946585cabcbe2d8f3cf052c01273f8
Bug: T78189
---
M pageviews/template.sql
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/multimedia
refs/changes/89/186089/1
diff --git a/pageviews/template.sql b/pageviews/template.sql
index fabcde0..fef543c 100644
--- a/pageviews/template.sql
+++ b/pageviews/template.sql
@@ -3,8 +3,8 @@
FROM (
SELECT
CONCAT(SUBSTR(day, 1, 4), '-', SUBSTR(day, 5, 2), '-', SUBSTR(day, 7,
2)) datestring,
- SUM(file_views) file_views,
- SUM(nonfile_views) nonfile_views
+ SUM(file_views) * 1000 file_views, -- NavigationTiming is sampled
1:1000
+ SUM(nonfile_views) * 1000 nonfile_views
FROM (
SELECT SUBSTR(timestamp, 1, 8) day, SUM(event_namespaceId = 6)
file_views, SUM(event_namespaceId != 6) nonfile_views
FROM NavigationTiming_10076863 WHERE %wiki% SUBSTR(timestamp, 1,
4) >= '2014' AND event_action = 'view' GROUP BY day
--
To view, visit https://gerrit.wikimedia.org/r/186089
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Id60d8b270c946585cabcbe2d8f3cf052c01273f8
Gerrit-PatchSet: 1
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: Gergő Tisza <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
