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)
Solution SageIt's gonna be a bummer given the sheer size of data. For example, in 2000 you have 2004 medals across 300 events, out of which Gold was 663 alone. From there, you can exclude the events with 1 gold medal but then you have a gray area where you had one team but multiple persons, like Tennis Men's Doubles. How do you want to count those: one medal or two? What about 4x100 Relay events?
Helper IMNedix
For multiple persons, like Tennis Men's Doubles and Relay events i want it to count as one medal per team.
- MNedix
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)
- RoxanaZaharia
Thank you so much for your help and for taking the time to respond!