Thunderbird/Support/Google Big Query Sample SQL queries: Difference between revisions
< Thunderbird | Support
Jump to navigation
Jump to search
(add desktop results) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
== Count All Solved Android Desktop Questions in 2024 == | == Count All Solved Android Desktop Questions in 2024 == | ||
* [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s1f1e6c74-be25-48e4-afa9-72f0704828c0!2e1 staff only link to BQ query] | * [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s1f1e6c74-be25-48e4-afa9-72f0704828c0!2e1 staff only link to BQ query] | ||
* results: | * results (4% solved): | ||
<pre> | <pre> | ||
tb_android_2024_aaq,solved_tb_android_2024 | tb_android_2024_aaq,solved_tb_android_2024 | ||
| Line 24: | Line 24: | ||
== Count All Solved Thunderbird Desktop Questions in 2024 == | == Count All Solved Thunderbird Desktop Questions in 2024 == | ||
* [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s3adc7726-d692-4123-8a42-50042d481727!2e1 staff only link to BQ query] | * [https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1smoz-fx-data-sumo-prod!2snorthamerica-northeast1!3s3adc7726-d692-4123-8a42-50042d481727!2e1 staff only link to BQ query] | ||
* results (13% solved): | |||
<pre> | |||
tb_desktop_2024_aaq,solved_tb_desktop_2024 | |||
15506,1970 | |||
</pre> | |||
<div class="mw-collapsible mw-collapsed" data-expandtext="show query"> | <div class="mw-collapsible mw-collapsed" data-expandtext="show query"> | ||
<pre> | <pre> | ||
Latest revision as of 19:41, 28 May 2025
Count All Solved Android Desktop Questions in 2024
- staff only link to BQ query
- results (4% solved):
tb_android_2024_aaq,solved_tb_android_2024 311,12
SELECT
COUNT(*) as tb_android_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_android_2024
FROM
moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
EXTRACT(YEAR
FROM
DATETIME(created_utc)) = 2024
AND product LIKE 'thunderbird-android'
;
Count All Solved Thunderbird Desktop Questions in 2024
- staff only link to BQ query
- results (13% solved):
tb_desktop_2024_aaq,solved_tb_desktop_2024 15506,1970
SELECT
COUNT(*) as tb_desktop_2024_aaq, COUNTIF(is_solved is true) AS solved_tb_desktop_2024
FROM
moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
EXTRACT(YEAR
FROM
DATETIME(created_utc)) = 2024
AND product LIKE 'thunderbird'
;
Count All Thunderbird Desktop Questions in 2024
SELECT
COUNT (*)
FROM
moz-fx-data-sumo-prod.mzla.metrics_thunderbird_questions
WHERE
EXTRACT(YEAR
FROM
DATETIME(created_utc)) = 2024
AND product LIKE 'thunderbird'
;