Missing values and Data Table

[acheriat]

Hi,
In Kibana, when I add a field with missing values to a "data table", a curious behavior occurs :
the rows that contains missing values disappear from the table data.

Would you have any idea to solve this problem?

Example :

After

[spalger]

It sounds like you are looking for #1961

Is that the case?

[acheriat]

Thanks for your answer,

If Kibana or ES don't be able to detect missing values, this is a big loss.

The advantage of NoSQ db, is to allow us to have rows whose structure can be different and therefore missing values for columns that are not specified.

Should I infer that i must replace all missing values by some thing?

[spalger]

Well, there are ways to see how many documents do not have a value for a specific field, but the purpose of the terms aggregation is to show you the top terms, nothing else. Consider turning your terms aggregation into a filter aggregation, and then filter on the rows you expect, maybe:

1. od_sexe:HOMME
2. od_sexe:FEMME
3. -od_sexe:*

[acheriat]

Tnaks for your answer ...

I agree that it meets the need but this only an example to illustrate my problem.
I think I did not set a full example. I am sorry.

Rather than the field "od_sexe" (where valuers filtering can be enumerable), Imagine another field "city" for example, where the possible range of values can be very large.

I think, we agree, that the solution below is not suitable.

PS: in the example above, I use the way "Terms aggragation" to generate a "data Table" that looks like Excel (name, sex, birth day, city, ...etc). I have not found another way to do it ...

[acheriat]

is there any idea for fields of type date that contains null values (vs enumerable fields)?

[rashidkpc]

As noted, this is a duplicate of #1961