In a data table visualization, I have a field that I use the metric count aggregation on. However, often the field is empty in many documents. When I try to use a bucket to split rows by terms in this field (to see the top counted terms), an empty result does not show up. (The field does exist in the document even when it is empty, and an empty is meaningful to me.) How can I make empty fields also show up in a count?
Or maybe there is a better way to do this (under the assumption that I cannot adjust documents with empty fields to be non-empty)?