i'm creating ES indices every month where one of the date fields can be empty for all documents from time to time. To make sure that visualizations do not break if this happens i added a mapping for this field to the index template.
New indices have the field in their mappings, as expected:
I have a table lens in a dashboard that should show some fields, including this, from all documents. But as soon as i add it, no more results are found. I thought the solution would be the "Include empty rows" switch, but it does not change the behaviour as expected. I thought the table would again show all documents with a "(missing value)" entry for the empty date fields.
I'm using Kibana 8.2. Is this fixed in a newer Version?
Edit: My solution so far was an extra string field containing '-' if the date is null, or the date as string otherwise. But i was trying to switch to a true date field such that the sorting an filtering is working as expected.
With a smal testsample i can see all three documents using the string version:
As soon as i add the true date field, the two documents without it disappear. The Include empty rows switch does nothing: