Mforns has uploaded a new change for review.
https://gerrit.wikimedia.org/r/282185
Change subject: Make browser reports show rates instead of percentages
......................................................................
Make browser reports show rates instead of percentages
Bug: T130406
Change-Id: I38ca7c5ac4b41481f6893da1bc32b47ec23794cd
---
M browser/all_sites_by_browser_family_and_major_percent
M browser/all_sites_by_browser_family_percent
M browser/all_sites_by_os_and_browser_percent
M browser/all_sites_by_os_family_and_major_percent
M browser/all_sites_by_os_family_percent
M browser/mobile_site_by_browser_family_and_major_percent
M browser/mobile_site_by_browser_family_percent
M browser/mobile_site_by_os_family_and_major_percent
M browser/mobile_site_by_os_family_percent
9 files changed, 9 insertions(+), 9 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/reportupdater-queries
refs/changes/85/282185/1
diff --git a/browser/all_sites_by_browser_family_and_major_percent
b/browser/all_sites_by_browser_family_and_major_percent
index 01b1ae0..2af9a3e 100755
--- a/browser/all_sites_by_browser_family_and_major_percent
+++ b/browser/all_sites_by_browser_family_and_major_percent
@@ -18,7 +18,7 @@
'$1' AS date,
browser_family,
browser_major,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/all_sites_by_browser_family_percent
b/browser/all_sites_by_browser_family_percent
index 7ae625e..dcfbba1 100755
--- a/browser/all_sites_by_browser_family_percent
+++ b/browser/all_sites_by_browser_family_percent
@@ -17,7 +17,7 @@
SELECT
'$1' AS date,
browser_family,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/all_sites_by_os_and_browser_percent
b/browser/all_sites_by_os_and_browser_percent
index 317a488..f15ce30 100755
--- a/browser/all_sites_by_os_and_browser_percent
+++ b/browser/all_sites_by_os_and_browser_percent
@@ -20,7 +20,7 @@
os_major,
browser_family,
browser_major,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/all_sites_by_os_family_and_major_percent
b/browser/all_sites_by_os_family_and_major_percent
index fe6a539..fa54540 100755
--- a/browser/all_sites_by_os_family_and_major_percent
+++ b/browser/all_sites_by_os_family_and_major_percent
@@ -18,7 +18,7 @@
'$1' AS date,
os_family,
os_major,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/all_sites_by_os_family_percent
b/browser/all_sites_by_os_family_percent
index b68af4b..89f35f3 100755
--- a/browser/all_sites_by_os_family_percent
+++ b/browser/all_sites_by_os_family_percent
@@ -17,7 +17,7 @@
SELECT
'$1' AS date,
os_family,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/mobile_site_by_browser_family_and_major_percent
b/browser/mobile_site_by_browser_family_and_major_percent
index 664efb9..f32d8a1 100755
--- a/browser/mobile_site_by_browser_family_and_major_percent
+++ b/browser/mobile_site_by_browser_family_and_major_percent
@@ -18,7 +18,7 @@
'$1' AS date,
browser_family,
browser_major,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/mobile_site_by_browser_family_percent
b/browser/mobile_site_by_browser_family_percent
index 8b15133..cf8c405 100755
--- a/browser/mobile_site_by_browser_family_percent
+++ b/browser/mobile_site_by_browser_family_percent
@@ -17,7 +17,7 @@
SELECT
'$1' AS date,
browser_family,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/mobile_site_by_os_family_and_major_percent
b/browser/mobile_site_by_os_family_and_major_percent
index 9fca96e..55cc465 100755
--- a/browser/mobile_site_by_os_family_and_major_percent
+++ b/browser/mobile_site_by_os_family_and_major_percent
@@ -18,7 +18,7 @@
'$1' AS date,
os_family,
os_major,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
diff --git a/browser/mobile_site_by_os_family_percent
b/browser/mobile_site_by_os_family_percent
index 6fcf03f..2b321f7 100755
--- a/browser/mobile_site_by_os_family_percent
+++ b/browser/mobile_site_by_os_family_percent
@@ -17,7 +17,7 @@
SELECT
'$1' AS date,
os_family,
- SUM(view_count) * 100 / view_count_total AS percent
+ SUM(view_count) / view_count_total AS percent
FROM slice JOIN total
GROUP BY
'$1',
--
To view, visit https://gerrit.wikimedia.org/r/282185
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I38ca7c5ac4b41481f6893da1bc32b47ec23794cd
Gerrit-PatchSet: 1
Gerrit-Project: analytics/reportupdater-queries
Gerrit-Branch: master
Gerrit-Owner: Mforns <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
