Nuria has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/365415 )
Change subject: Add sunburst graph to "desktop by browser" tab
......................................................................
Add sunburst graph to "desktop by browser" tab
Reports will populate since data is available
Bug: T170286
Change-Id: Ic85620140cac23575d453ca52bd7602c5f7bd215
---
M browser/config.yaml
A browser/desktop_site_by_browser_family_and_major
2 files changed, 26 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/reportupdater-queries
refs/changes/15/365415/1
diff --git a/browser/config.yaml b/browser/config.yaml
index 26985fa..26a48ac 100644
--- a/browser/config.yaml
+++ b/browser/config.yaml
@@ -127,3 +127,9 @@
starts: 2015-06-07
lag: 86400 # wait 1 day to compute last week
+ desktop_site_by_browser_family_and_major:
+ type: script
+ granularity: weeks
+ funnel: true
+ starts: 2015-06-07
+ lag: 86400 # wait 1 day to compute last week
diff --git a/browser/desktop_site_by_browser_family_and_major
b/browser/desktop_site_by_browser_family_and_major
new file mode 100755
index 0000000..99c9422
--- /dev/null
+++ b/browser/desktop_site_by_browser_family_and_major
@@ -0,0 +1,20 @@
+#!/bin/bash
+hive -e "
+ SELECT
+ '$1' AS date,
+ browser_family,
+ browser_major,
+ SUM(view_count) as view_count
+ FROM wmf.browser_general
+ WHERE
+ access_method = 'desktop' AND
+ CONCAT(year, '-', LPAD(month, 2, '0'), '-', LPAD(day, 2, '0')) >= '$1'
AND
+ CONCAT(year, '-', LPAD(month, 2, '0'), '-', LPAD(day, 2, '0')) < '$2'
+ GROUP BY
+ '$1',
+ browser_family,
+ browser_major
+ ORDER BY view_count DESC
+ LIMIT 1000
+ ;
+" 2> /dev/null | grep -v parquet.hadoop
--
To view, visit https://gerrit.wikimedia.org/r/365415
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic85620140cac23575d453ca52bd7602c5f7bd215
Gerrit-PatchSet: 1
Gerrit-Project: analytics/reportupdater-queries
Gerrit-Branch: master
Gerrit-Owner: Nuria <nu...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
