I'm trying to create a variety of visualizations based on aggregates. The index is holding financial transactions, and I'm looking for accounts with outstanding balances. The simplest visualization is a data table that splits rows into buckets based on terms. I'd like to exclude all of the buckets/rows where the sum of a field is zero. Based on my reading, I believe that this is not possible.
How can this be shown in Kibana?