43
edits
Telemetry/LongitudinalExamples: Difference between revisions
Add an example about the scalars
m (Fix typo in longitudinal recent submission date query) |
(Add an example about the scalars) |
||
| Line 81: | Line 81: | ||
SELECT * FROM longitudinal | SELECT * FROM longitudinal | ||
WHERE DATE_DIFF('day', DATE_PARSE(submission_date[1], '%Y-%m-%dT00:00:00.000Z'), current_date) < 7 | WHERE DATE_DIFF('day', DATE_PARSE(submission_date[1], '%Y-%m-%dT00:00:00.000Z'), current_date) < 7 | ||
* Scalar measurement (how many users with more than 100 tabs) | |||
WITH samples AS | |||
(SELECT | |||
client_id, | |||
normalized_channel as channel, | |||
mctc AS max_concurrent_tabs | |||
FROM longitudinal | |||
CROSS JOIN UNNEST(scalar_parent_browser_engagement_max_concurrent_tab_count) as t (mctc) | |||
WHERE | |||
scalar_parent_browser_engagement_max_concurrent_tab_count is not null and | |||
normalized_channel = 'nightly') | |||
SELECT approx_distinct(client_id) FROM samples WHERE max_concurrent_tabs > 100 | |||
=== Using Views === | === Using Views === | ||