0

I have used below query to get the total number of requests by regions in last 30 days.

 requests
| summarize count_=sum(itemCount), avg(duration)
  by bin(timestamp, 1h), client_StateOrProvince, client_City
| order by timestamp asc, client_StateOrProvince, client_City

Here is results

enter image description here

But, I am looking for region wise (west us, east us..) , I am not able to find right column names?

EranG
  • 822
  • 4
  • 10
kudlatiger
  • 3,028
  • 8
  • 48
  • 98

1 Answers1

1

Application Analytics schema does not have a geo-region defined for requests.

In addition to the columns in your summarize statement, you can also add client_CountryOrRegion to get the country (although this will give you "United States" and not "West US")

EranG
  • 822
  • 4
  • 10