# Rank customers by counter\_rate **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [February 7, 2025, 1:56pm UTC](https://discuss.elastic.co/t/rank-customers-by-counter-rate/374227 "2025-02-07T13:56:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Annxii](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@Annxii](https://discuss.elastic.co/u/Annxii)\ **Post date:** [February 7, 2025, 1:56pm UTC](https://discuss.elastic.co/t/rank-customers-by-counter-rate/374227/1 "2025-02-07T13:56:35Z")
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) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [February 12, 2025, 11:36am UTC](https://discuss.elastic.co/t/rank-customers-by-counter-rate/374227/2 "2025-02-12T11:36:06Z")
Hi @Annxii unfortunately this is [not currently possible to achieve in Lens](https://github.com/elastic/kibana/issues/197035). 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](https://github.com/elastic/kibana/issues/187753)