jenkins-bot has submitted this change and it was merged.
Change subject: Add image right clicks to stats
......................................................................
Add image right clicks to stats
Bug: T75962
Change-Id: Ia0c90cd8528d1d92bb658185be6183f6a4407982
---
M actions/template.sql
1 file changed, 5 insertions(+), 1 deletion(-)
Approvals:
Gilles: Looks good to me, approved
jenkins-bot: Verified
diff --git a/actions/template.sql b/actions/template.sql
index f936ea5..d983820 100644
--- a/actions/template.sql
+++ b/actions/template.sql
@@ -61,7 +61,8 @@
SUM(CASE WHEN event_action = 'enable-about-link' THEN
event_samplingFactor ELSE 0 END) AS 'enable-about-link',
SUM(CASE WHEN event_action = 'image-unview' THEN event_samplingFactor
ELSE 0 END) AS 'image-unview',
SUM(CASE WHEN event_action = 'metadata-scroll-open' THEN
event_samplingFactor ELSE 0 END) AS 'metadata-scroll-open',
- SUM(CASE WHEN event_action = 'metadata-scroll-close' THEN
event_samplingFactor ELSE 0 END) AS 'metadata-scroll-close'
+ SUM(CASE WHEN event_action = 'metadata-scroll-close' THEN
event_samplingFactor ELSE 0 END) AS 'metadata-scroll-close',
+ SUM(CASE WHEN event_action = 'right-click-image' THEN
event_samplingFactor ELSE 0 END) AS 'right-click-image'
FROM (
SELECT timestamp, event_action, 1 AS event_samplingFactor FROM
MediaViewer_7670440
@@ -94,6 +95,9 @@
SELECT timestamp, event_action, event_samplingFactor FROM
MediaViewer_10606177
WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND
timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
UNION ALL
+ SELECT timestamp, event_action, event_samplingFactor FROM
MediaViewer_10867062
+ WHERE %wiki% timestamp < TIMESTAMP(CURDATE()) AND
timestamp >= TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY))
+ UNION ALL
SELECT timestamp, (CASE WHEN event_value = 0 THEN
'pref-optout-loggedin' ELSE 'pref-optin-loggedin' END) AS event_action, 1 AS
event_samplingFactor FROM PrefUpdate_5563398
WHERE event_property = 'multimediaviewer-enable' AND
timestamp < TIMESTAMP(CURDATE()) AND timestamp >= TIMESTAMP(DATE_SUB(CURDATE(),
INTERVAL 30 DAY))
) AS MediaViewerUnioned
--
To view, visit https://gerrit.wikimedia.org/r/182404
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ia0c90cd8528d1d92bb658185be6183f6a4407982
Gerrit-PatchSet: 2
Gerrit-Project: analytics/multimedia
Gerrit-Branch: master
Gerrit-Owner: Gergő Tisza <[email protected]>
Gerrit-Reviewer: Gilles <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
