Requirement : Synthetic monitoring script was developed and scheduled to run across 5 different locations. We would like to see the load times of any page in a table and provide a comparison against the expected load time for that location. For example, lets say a website is accessed from 5 different locations, the expected load time from location1 could be 5 seconds, while from location2 could be 7 seconds, location3 could be 2 seconds, location4 could be 4 seconds, location5 could be 10 seconds.
How can we achieve this in NRQL (refer to the attachment ) ?
Please refer to dashboard which is currently worked upon