How to get unique count with a condition?

Hello,
I am new in kibana and would like to know how can I do a unique count applying a condition?

For example:
Unique customers (customerid field) count where sales(sales field) are greater than $100
Can i create this unique count measure as a scripted field? because then I would need it on a map.

Thanks in advanced

There is an option 'Unique count'
image

Hi !!!
Yes, but i need to add a condition to that "Unique Count", for example : unique count of customer WHERE Sales > $100

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