Kibana: map heat map score to set of numbers?

Is there a way, using the formula for the heat map score, to map a count of the items into a limited domain of numbers?

if there are < X number of these items, assign a 0
if there are between 1 and 5 of these items, assign 1
if there are 5+ or more of thees items, assign 2


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Hi @smchamberlin

welcome to the Kibana community.
Yes, you can use conditionals for that:

ifelse( count() < 1, 0, ifelse( count() < 5, 1, 2))