Jul 10 2018
11:02 PM
- last edited on
Apr 07 2022
05:14 PM
by
TechCommunityAP
Jul 10 2018
11:02 PM
- last edited on
Apr 07 2022
05:14 PM
by
TechCommunityAP
I need to add both unhealthy and healthy VM count in a single graph?
I have the query for individual graphs from https://blogs.technet.microsoft.com/robdavies/2017/12/29/monitoring-application-gateway-with-azure-l...
Jul 12 2018 01:38 PM - edited Jul 12 2018 04:49 PM
Hi,
Without knowing the details of the shape of your data, the general pattern I'd follow is the following:
let q1 = (){ query1_goes_here | extend state = "healthy" }; let q2 = (){ query2_goes_here | extend state = "unhealthy" }; union q1,q2 | summarize ... by ..., bin(timestamp, ...), state | render ...
Hope that helps, but if you need more specific help, please provide some sample data for both queries (even if the data is the general shape and mocked up with fake values), and we can help put a more specific query together.