I am running below query to get WEBSITES pages information and their performance, but I also need COUNTRY information like from which country the page is.
Please help me how i can get country information with the below query.
SELECT average(duration) as
Avg Total Duration, average(duration)-average(backendDuration) as
Avg Frontend Duration, average(backendDuration) from PageView where appName like ‘www.tena%’ and pageUrl like ‘%tena%’ facet pageUrl limit 1000 SINCE ‘2017-07-17 00:00:00 cet’ until ‘2017-10-24 00:00:00 cet’