AzureDiagnostics | where ResourceType == "SEARCHSERVICES" | where OperationName == "SearchQuery" | summarize TotalQueries = count(), SuccessfulQueries = countif(HttpStatusCode == 200), FailedQueries = countif(HttpStatusCode != 200) by bin(TimeGenerated, 1h) | extend SuccessRate = (todouble(SuccessfulQueries) / todouble(TotalQueries)) * 100, FailureRate = (todouble(FailedQueries) / todouble(TotalQueries)) * 100 | project TimeGenerated, SuccessRate, FailureRate