Rank functions not showing

[3isenHeiM]

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:

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!

[Marco_Liberati]

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?

[3isenHeiM]

Thanks for the info.

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

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

[3isenHeiM]

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