Kibana Visualize - Display count even if field not exists

Hello! First time posting here, I've been looking around but haven't found anything to point me towards the right direction to solve my issue.

I'm creating a data table which contains an aggregation by Terms for a date type field (order by metric:count).

However, for some of the files we have in our dataset this field does not exist.

Is there any way to display this field in the data table even if it doesn't exist for a given file?

That is, is it possible to display this column in the data table and for files that do not contain this field may appear as empty or NULL values?

Many thanks in advance for your help and kind regards,

Hi @Pedro_Ventura

welcome to the Kibana community.
Do you know in advance such field names? Perhaps Filters can be a solution in place of Top Values?

1 Like

Hi @Marco_Liberati !

Many thanks for your response on this.

Yes, I know in advance the name of such fields. Should I be using Filters instead of Terms?


From what I understand, the filter is like a query (with the same language) so I put filter 1 = the field does not exist, filter 2 = the field exists and it gives me this:

It clearly identifies the cases in which the field is empty, but when it is not empty it appears like this instead of the date:

How can I make the date appear in cases where it exists and in cases where it doesn't, it just presents me with a "-" or empty value?

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