Hey @reopelle.scott - While you could construct a query to use
filter in order to grab throughput and response time, you can see from my screenshot that this does not return great results.
SELECT filter(count(*), where appName = 'myAppName' ) as 'Throughput', filter(average(duration), where appName = 'myAppName') as 'Response Time' FROM Transaction TIMESERIES since 2 hours ago
A typical expectation is for throughput to be > 30, and response time to be < 2s
As you can see - as there’s no way to have dual Y-Axis, the throughput makes it near impossible to interpret the response time from this chart.
Instead I would recommend having two widgets side by side in one dashboard. One widget with your query targeting the throughput, and another query exactly the same looking at the
average(duration). If both queries are looking at the same timeframe then you’ll be able to correlate a spike in throughput to a spike in response time.
Alternately, if you remove
timeseries from the query I shared above, you can get 2 numeric values, one for throughput and one for the response time, in the one widget.
Hope that helps