Filter results on "Unique Count" aggregation

[jaimin161 (Jaimin Patel)]

I'm building Data Table visulizer in Kibana, where I'm using Unique Count aggregation. It returns data correctly.

But my users needs to filter data based Unique Count (Show results <= #n of Unique Counts).

Any help would be appreciated.

Ex: in below screen shot, we would like to show only those DBs where Unique SQL Count is <= 321.

[nickpeihl]

Hi @jaimin161. I do not see a way to do this currently. I think we need to implement the bucket selector pipeline aggregation in Kibana to make this possible. Feel free to express your use case and need in this issue. https://github.com/elastic/kibana/issues/17544

[jaimin161 (Jaimin Patel)]

Pretty disappointing. Any alternatives?

[nickpeihl]

Hi @jaimin161 I have found no alternatives. As I said, the best thing you can do for now is express your need in the aforementioned GitHub issue.