Hello @Rajith pathiraja ,
I understand that you want to get the top 10 countries for the most requests received by your Application gateway.
However, this is not possible as of today.
If you look into the Application gateway Access log or Firewall Log values, you will only find "clientIP" as below:
So, there is no way to summarize the logs by country information.
Summarizing logs by country information is only possible where the logs have a value called "clientCountry". For example Application Insights logs called "AppRequests".
Refer : https://learn.microsoft.com/en-us/azure/azure-monitor/app/convert-classic-resource#appavailabilityresults
You can find a value called "client_CountryOrRegion" in this log to summarize your logs by this function/value and can render the data using a area/bar/column/pie/scatter/table/time/treemap chart as below:
For Application gateway, you can only get Top 10 Client IPs as shown in my previous screenshot and mentioned in the below doc:
https://learn.microsoft.com/en-us/azure/application-gateway/monitor-application-gateway#sample-kusto-queries
Kindly let us know if the above helps or you need further assistance on this issue.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.