How to get Throughput chart?

[Gleb_Gadyatskiy]

Hi,

We recently switched to AppD and I am looking for a way to get a Throughput chart (hits/second) for specific Transaction records.

For example, I have a query: SELECT * FROM transactions WHERE segments.httpData.cookies.WeToken='WS757982604da45a81' LIMIT 10000

and I like to visualize Throughput for these transactions. I can see a small chart in Analytics UI, but it gives me no control over time steps, etc.

Please suggest how to visualize Throughput.

[Gleb_Gadyatskiy · Accepted solution]

Found it: SELECT series(eventTimestamp, '1s'), count(*) FROM transactions WHERE segments.httpData.cookies.WeToken='WS757982604da45a81' LIMIT 10000