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.
I think what you are looking for is the pick_min function in Formula:
pick_min(ceil(count(kql='type.keyword="aha"') / 2), 2)