Query editor
WITH latency AS (SELECTsymbol,CASEWHEN latency < 1 THEN '< 1 mins'WHEN latency >= 1 AND latency < 2 THEN '1 mins'WHEN latency >= 2 AND latency < 3 THEN '2 mins'WHEN latency >= 3 AND latency < 6 THEN '3 - 6 mins'WHEN latency >= 6 AND latency < 12 THEN '6 - 12 mins'WHEN latency >= 12 AND latency < 24 THEN '12 - 24 mins'WHEN latency >= 24 AND latency < 60 THEN '24 - 60 mins'ELSE '>= 1hr' -- Catch-all for latencies >= 60 minsEND AS latency_bucketFROM query_4341587)SELECTlatency_bucket,symbol,COUNT(*) AS frequencyFROM latencyGROUP BY 1, 2