canmove, Confirmed users, Bureaucrats and Sysops emeriti
2,798
edits
Mobile/Metrics/Redash: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
MarkFinkle (talk | contribs) (Created page with "This page explains how to use Mozilla's [https://sql.telemetry.mozilla.org/ Re:dash] query and visualization system. == Overview == [http://docs.redash.io/en/latest/index.ht...") |
MarkFinkle (talk | contribs) mNo edit summary |
||
| Line 43: | Line 43: | ||
channel varchar channel name (parition) | channel varchar channel name (parition) | ||
submission varchar submission as a string 'YYYYMMDD' (partition) | submission varchar submission as a string 'YYYYMMDD' (partition) | ||
== Useful Queries == | |||
This guide doesn't try to teach SQL, but assumes you have a basic understanding. | |||
=== Looking at Events === | |||
You want to look at basic UI Telemetry over the last 7 days, like the UI Telemetry dashboard: | |||
select | |||
submissiondate as date, | |||
channel, | |||
action, | |||
method, | |||
extras, | |||
count(*) as count | |||
from android_events_v1 | |||
where | |||
submissiondate > current_date - interval '7' day | |||
group by 1, 2, 3, 4, 5 | |||
Same, but only those events that happened during a <code>firstrun</code> session: | |||
select | |||
submissiondate as date, | |||
channel, | |||
action, | |||
method, | |||
extras, | |||
count(*) as count | |||
from android_events_v1 | |||
where | |||
submissiondate > current_date - interval '7' day and sessions like '%firstrun%' | |||
group by 1, 2, 3, 4, 5 | |||