Group by in our KPI implementation does not capture null values. The run below does not contain the count where crop is null:
null
crop is null
Entities must be left joined in JPA for null to be considered as a "group". JPA defaults to inner join.