Request per second - Dashboards - Allow per second granularity?

[alok87]

HyperDX does not allow to have a RPS/TPS (request per second or transaction per second) like dashboards.

toStartOfInterval (toDateTime (Timestamp), INTERVAL 1 minute) AS `__hdx_time_bucket`

Allow 1 second? any reason we dont allow?

[MikeShi42]

@alok87 in this case you might actually want to do count() / 60 with a minute granularity to do RPS (averaged over a minute). We can add 1 second granularity - but that may load a lot of data points into the browser.

[alok87]

@MikeShi42 how to do this but? The dashboard of Line/Bar does not allow to do count/60 - Dashboard is a bit restrictive to write SQL queries at present.

[MikeShi42]

We introduced a new None aggregation option which will allow you to write arbitrary SELECT statements. However because it's completely user defined, we can't populate the WHERE condition for you (since sometimes it uses the If combinator for multiple series) - so you'll need to use an If combinator manually.

Here's an example: