I have league game's linescores stored in an index. For each game, the team could be in either:
for Boston Bruin away games:
linescore.teams.away.team.name: Boston Bruins
or for Boston Bruin home games:
linescore.teams.home.team.name: Boston Bruins
ie for home games they are in latter, away former.
I can't figure out how to create a data table which lists the teams, and has 3 columns: Total Games, Home Games, Away Games. Simple count for each of those fields.
I can get it to show teams and the count of say away games by a count on one of those fields above. But how would I get the table to bucket up counts for when the team could be in either of those two fields?