[BigQuery + Firebase Performance Monitoring] Find app screens with frozen frames impacting French users

firebase_performance_slow_screens.sql

SELECT
  AVG(trace_info.duration_us / 1000000) AS seconds_on_screen,
  AVG(trace_info.screen_info.slow_frame_ratio) AS slow_frame_ratio,
  AVG(trace_info.screen_info.frozen_frame_ratio) AS frozen_frame_ratio,
  event_name as screen,
  country
FROM `ibam-d6cd2.firebase_performance.iba_mobilbank_IOS`
WHERE _PARTITIONTIME > TIMESTAMP("2019-05-09")
AND event_type = "SCREEN_TRACE"
AND country = "FR"
GROUP BY event_name, country
ORDER BY frozen_frame_ratio desc;