Forum Discussion

Kenmare's avatar
Kenmare
Frequent Visitor
3 years ago
Solved

Count values which can be on two different columns

Hi there ! I'm creating a dashboard to study each strategy for a football team with these tables :     In my report: a slicer to select a team. I want to display, for each strategy, ho...
Need Help
Kenmare's avatar
Kenmare
Frequent Visitor
3 years ago

Thank you Ahmedx this is what I was searching for this visual.

Anonymous the logic was to calculate the number of occurrences of each strategy: if the team plays at home (in team_1_id) + away (in team_2_id)