The percentage of website that are assessed as having good FID on desktop and mobile (where applicable).

pct_good_fid.sql

WITH origins AS (
  SELECT
    origin,
    LOGICAL_AND((fast_fid / (fast_fid + avg_fid + slow_fid)) >= 0.75) AS good_fid
  FROM
    `chrome-ux-report.materialized.device_summary`
  WHERE
    date = '2023-09-01' AND
    device IN ('desktop', 'phone') AND
    fast_fid IS NOT NULL
  GROUP BY
    origin
)

SELECT
  COUNTIF(good_fid) / COUNT(0) AS pct_good_fid
FROM
  origins