See https://codesandbox.io/s/wizardly-oskar-407wjl?file=/App.tsx The group value should not be what the aggregation is but rather what the grouping is - see "group by team" column in the picture below 