# Rank functions not showing

**URL:** <https://discuss.elastic.co/t/rank-functions-not-showing/374407>\
**Category:** Kibana\
**Tags:** lens\
**Created:** [February 12, 2025, 8:50am UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407 "2025-02-12T08:50:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![3isenHeiM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/3isenheim/32/141313_2.png) [@3isenHeiM](https://discuss.elastic.co/u/3isenHeiM)\
**Post date:** [February 12, 2025, 8:50am UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407/1 "2025-02-12T08:50:10Z")

</div>

Hi,

Between 2 ELK instances of the same version (8.12.2), and the same data type (keyword), the ranking functions proposed are not the same.

On the first one, I can ran the vertical axis of my bar graph percentage by Average, LastValue, FirstValue, Count, Median, ...

While on the second instance, I can only ran them by Count and UniqueCount.

Here is the "restricted options" in the rank by dropdown:

 ![2025-02-12-094319](https://us1.discourse-cdn.com/elastic/original/3X/a/c/ac5a08744ae9dd0c845d6803c102a7cb53900138.png)

The field "payload\_category" is a keyword in the index.

How come I cannot rank this field by "Median, Minimum, ..." ? What am I missing ?

Thanks!

---

<div class="post-metadata">

**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:27am UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407/2 "2025-02-12T11:27:25Z")

</div>

Hi @3isenHeiM

the list of possible aggregations to be performed in a Lens chart is computed by the field list types provided for the given data view.  
If you have a `dataView` with only a `keyword` field then only `Count` and `Unique Count` would be provided.  
On the other hand if your `dataView` contains at least one numeric field, then other types of aggregations can be performed (i.e. Median, Average, etc...).

On the instance with only the two count functions, what is the list of fields for the given dataView?

---

<div class="post-metadata">

**Author:** ![3isenHeiM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/3isenheim/32/141313_2.png) [@3isenHeiM](https://discuss.elastic.co/u/3isenHeiM)\
**Post date:** [February 12, 2025, 12:12pm UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407/3 "2025-02-12T12:12:51Z")

</div>

Thanks for the info.

Here is the dataview fields available. As of now, indeed no field are numerical.

 ![2025-02-12-131024](https://us1.discourse-cdn.com/elastic/original/3X/6/5/65971075a379f2a5f6aa9d97b48d31821b3fcf6c.png)

Is there a way to circumvent this, or should I modify the data ingested to add a numeric 'dummy' value ?

---

<div class="post-metadata">

**Author:** ![3isenHeiM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/3isenheim/32/141313_2.png) [@3isenHeiM](https://discuss.elastic.co/u/3isenHeiM)\
**Post date:** [February 12, 2025, 1:13pm UTC](https://discuss.elastic.co/t/rank-functions-not-showing/374407/4 "2025-02-12T13:13:29Z")

</div>

BTW: as temp fix, I've added a long field to my index and now I see all the other ranking functions.