No support for nested math in formula?

[smchamberlin]

Hello,

I was able to get this working in python, but getting the following error when I try to nest math functions in an equation for a heat map lens:

Is this not supported? Thank you.

[Marco_Liberati]

Hi @smchamberlin

I think what you are looking for is the pick_min function in Formula:

pick_min(ceil(count(kql='type.keyword="aha"') / 2), 2)

[smchamberlin]

Thanks Marco - that helped