Hi All, I am new to ADQL, and currently looking to build a query that provides me with a flat table, to show data for last 12 months, showing Country x Number of Pages x Page Load Times x Dates Basically I need to find out what page load speed is at peak and normal time by geography. This query does return Country, Page Count & Average Response Time, but I'm unable to tailor the query to return dates: SELECT geocountry, count(*), avg(metrics.`End User Response Time (ms)`) FROM browser_records WHERE appkey = "EC-AAD-PRA" AND geocountry IS NOT NULL ORDER BY geocountry LIMIT 1000
... View more