How can i exclude 0 from an uniqe count?

Hi,
I have to do a Visualization that only shows the data over 10 of an unique count i tried "clamp(unique_count('info.job-id.keyword') - 10, 0, 1) * unique_count('info.job-id.keyword')" . Now i have all the data under 10 with a zero and the data above shows the normal unique count value the Problem is i need to exclude all values with 0 so that the Visualization only shows the values over ten.
Does anyone have an Idea to solve this Problem?

Assuming this is lens you can just put a KQL query in the KQL query bar something like

not info.job-id.keyword: 0

Which will exclude all document with info.job-id.keyword: 0
Perhaps I am not understanding.

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