Visualisation challenge - not able to include documents without field

Elastic Stack Kibana
1

Hello, first time poster here so be gentle with me :slight_smile:

When creating a Visualisation (for example: Lens - Top Values), there is an option to pick a field and in "Advanced" section to check "Include documents without this field".
When I want to use a Number field, this checkbox is disabled for me. Is this expected and why is that?

Challenge that I have is that if I want to show 2 number fields on the same dashboard in similar manner, I have a challenge that these two fields are mutually excluding one another in a way that some records have field1 set and other have field2 set. Since I cannot pick "Include documents without this field", I end up without any field.

Is there any workaround for this?

Kind Regards

2

Hi Damir, sorry for the very late answer. Maybe you could create a runtime field which value is determined by whether field a or field b exists and make your visualization on top of the newly created field. If that's not helpful, please describe what kind of visualization you're looking for?