Hello DT Community,
Thank for always helping out. I need help developing two USQL queries:
I’m currently, daily pulling out 2 sets of SLA stats.
Solved! Go to Solution.
I don't think this is achievable via USQL, but should be easily doable with the data explorer + SLOs functionality:
1. Way to go would be using that multidimensional analysis screen to create a custom metric that counts all the requests that take less than 1s. Similar to this:
Then creating an SLO that calculates the ratio that you mention: requests(<1s)/requests.
2. This is also something that could directly be achieved with Data explorer, with a structure similar to this (in this case: hourly 90th percentile response time for an entire day and a specific service, you can tailor that to your other requirements):
Only caveat is that the "public holiday" part of the request isn't something that Dynatrace can really do, but you can just use the timeframe to select that period of time.