Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
Filter to just the Finals rows. Convert WRank/LRank to Double. Determine Rank Difference. Summarize tournaments by number of Finals. Filter to tournaments with greater than 19 Finals. Sort by Avg. Rank Difference. Find Tournament with highest rank difference. In separate workstream, determine the number of times each winner won in each tournament. Join the two outputs by the tournament from your first workstream, thus filtering to just the winners of that tournament. Sort by most wins, then filter by the top option. Andujar P. 3 wins.
Filter to just the Finals rows. Convert WRank/LRank to Double. Determine Rank Difference. Summarize tournaments by number of Finals. Filter to tournaments with greater than 19 Finals. Sort by Avg. Rank Difference. Find Tournament with highest rank difference. In separate workstream, determine the number of times each winner won in each tournament. Join the two outputs by the tournament from your first workstream, thus filtering to just the winners of that tournament. Sort by most wins, then filter by the top option. Andujar P. 3 wins.
