Query for Average response time based on a sub set of the Azure Subscription

Hi Stephen, welcome aboard :)

First I'd just note it might be easier to manage separate sites over separate Application Insights resources, that would help you monitor each site separately.

To your question, I would suggest to create a runtime field (let's call it "domain" in this example) and then calculate the average duration for each domain. `parse` is a cool command that's meant for this kind of string parsing:

requests
| parse url with "https://" domain "/" *
| summarize avg(duration) by domain

if some of your sites start with "http" and some with "https", the parse pattern should be a bit different:

requests
| parse url with * "://" domain "/" *
| summarize avg(duration) by domain

HTH,

Noa