Forum Discussion
Helper Ihow can i solve this?
If you really want to do that you'll have to create a calculated column or measure in which you have to manually configure what is single vs. team; this means going through over 1000 events. Keep in mind that you have teams ranging from 2 (like tennis or other doubles) to 24 people per team (like baseball). You could actually be safe(er) if you go the other way around: instead of going through every event and understand if that event is single person or multi-person you could consider all 1's as single medals and >2 as teams (see screenshot).
Then you can use the new column/measurein subsequent calculations for the purpose you need. (the screenshot is a snippet of Gold medals in 2000)
Helper IMNedix
For multiple persons, like Tennis Men's Doubles and Relay events i want it to count as one medal per team.
Solution SageIf you really want to do that you'll have to create a calculated column or measure in which you have to manually configure what is single vs. team; this means going through over 1000 events. Keep in mind that you have teams ranging from 2 (like tennis or other doubles) to 24 people per team (like baseball). You could actually be safe(er) if you go the other way around: instead of going through every event and understand if that event is single person or multi-person you could consider all 1's as single medals and >2 as teams (see screenshot).
Then you can use the new column/measurein subsequent calculations for the purpose you need. (the screenshot is a snippet of Gold medals in 2000)
- RoxanaZaharia
Thank you so much for your help and for taking the time to respond!