Kibana Discover field statistics not showing

[joshuachough]

I have some data I am trying to get statistics on (e.g. what percentage of documents have a description?). However, the field statistics are not showing, even when I hit refresh...

When I click on one of the fields, it shows me some of the distinct values, but not all...

Is there a way to fix this?

[kaismax (KAIS)]

can you share the mapping for your index

[joshuachough]

{
  "experts": {
    "mappings": {
      "properties": {
        "country": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "description": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "fullName": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "id": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "infoFromLinkedin": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "internal_tags": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "medical_specialties": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "organization": {
          "properties": {
            "_id": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            },
            "altNames": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            },
            "name": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            },
            "type": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            }
          }
        },
        "projects": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "status": {
          "type": "keyword"
        },
        "technology_tags": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "title": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        }
      }
    }
  }
}

[jughosta (Julia Rechkunova)]

Hi @joshuachough and welcome to the community!

Field Statistics can be provided for aggregatable fields like fields with keyword type. In your case looks like mostly text fields are selected.

There are 2 options for you to try:

1. deselect all currently selected fields (for example by pressing New link in the top nav)
2. select aggregatable fields too (for example, add country.keyword field via "+" from the sidebar field popover)

[Quynh_Nguyen]

Hi Joshua. I've created an enhancement request here [ML] Shows some stats for non-aggregatable fields in Field statistics · Issue #160280 · elastic/kibana · GitHub for this issue.

[joshuachough]

Thank you! That works!