Rank customers by counter_rate

Hi,

I'm trying to make a tabular visualization of the top 10 customers measure on req/sec.

I have a monotonically increasing counter with the customer as an attribute. My counter_rate is working fine, my issue is that I cannot get the result of counter_rate as the metric for the ranking function when selecting my customer as the label.

I kinda need the result from counter_rate if I'm to trust the result. The standard statistical functions available are all unreliable in case of counter resets.

Am I missing something here?

Alternatively, is it possible to make a transformation or similar which will allow me to pre-calculate the counter_rate into a gauge metric? (I generally cannot find counter_rate anywhere else than through Lens)

Hi @Annxii

unfortunately this is not currently possible to achieve in Lens.
When ES|QL will support it it would be possible, so make sure to track this issue: [ES|QL] add rate agg · Issue #187753 · elastic/kibana · GitHub