When a field with null-values in elasticsearch, is added as row/column it automatically filters my report on records without null-value.
Example: [{name:'sample 1', note:'...'},{name:'sample 2',note:null}]
when adding note as row/column "sample 2" will be filtered.
I expected the empty value (like in kibana).
Is this possible without replacing null with "" in the elasticsearch index?
Hello, Abons,
Thank you for writing to us.
We already have a min_doc_count
property which can be set in the mapping object. It can be used to show intervals with empty values for date histogram. For more details please check our docs: https://www.flexmonster.com/api/data-source-object/.
Our team agrees it would be nice to have such a property for other data types as well, not just dates. We have added this request to our improvements list.
Could you please let us know if it's critical for your evaluation?
Regards,
Tanya