🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

how can i show null-values in elastic-search object as empty string

abons asked on May 15, 2019

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?

1 answer

Tanya Gryshko Tanya Gryshko Flexmonster May 15, 2019

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?


Please login or Register to Submit Answer