"No data" when grouping by one ES term but not another

I have some data which shows up as No data when I attempt to Group By the term extraction.grade but not when I group by other terms, e.g. team.name.

What could explain why I am unable to see any data when grouping by extraction.grade ? You can see in the raw-data view that my data exists and has meaningful values in the extraction.grade column.

In this screenshot, you can see data grouped by team.name. The data are present.

In this screenshot, you can see data grouped by extraction.grade. The data are absent.

In this screenshot, you can see the raw data. The extraction.grade column holds meaningful data, and none of the values is empty/missing.

How is mapping for document fields defined in your ES? Some fields may not have suitable type for grouping.

extraction.grade is text, and team.name is keyword

I guess that’s the answer. I don’t believe that you can group on text field - check ES doc if you want to be 100% sure.
You may have extraction.grade.keyword. Your target is to have keyword type, which can be used for grouping.

1 Like