If condition in Kibana Table Visualization

Elastic Stack Kibana
6

Hi @micaelle,

while there's no current conditional helpers yet available in Lens, it is possible to achieve something like you want using some math. I've written some explanation in here on how to leverage the clamp function for this use case: Dec 4th, 2021: [en] Advanced trick and tips in Lens

In your example, you probably have to add one more layer of complexity there as you depends on two distinct conditions:

(
clamp( count(operations.keyword pix.sent) + count(operations.keyword pix.received) - 500, 0, 1) + 
clamp( unique_count(account_id.keyword) - 100, 0, 1)
) * 2000
1 Like