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
I like the "SUCCESS" field in the output. Let's get some tubas to those kids!
Spoiler
Process:
- Calculate Pct of HH with school-age kids
- Calculate Pct of HH with families
- Sort by Pct of HH with school-age kids (desc)
- Assign RecordID to Pct of HH with school-age kids
- Sort by Pct of HH with families (desc)
- Assign RecordID to Pct of HH with families
- Sort by Avg HH Spend on musical instruments (desc)
- Assign RecordID to Avg HH Spend on musical instruments
- Calculate Avg of the three ranks calculated above, i.e. Overall Rank
- Sort by Overall Rank (Asc)
- Calculate Running Total of HH
- Filter for Running Total <= 10000
- Clean-up fields for comparison
- Calculate Pct of HH with school-age kids
- Calculate Pct of HH with families
- Sort by Pct of HH with school-age kids (desc)
- Assign RecordID to Pct of HH with school-age kids
- Sort by Pct of HH with families (desc)
- Assign RecordID to Pct of HH with families
- Sort by Avg HH Spend on musical instruments (desc)
- Assign RecordID to Avg HH Spend on musical instruments
- Calculate Avg of the three ranks calculated above, i.e. Overall Rank
- Sort by Overall Rank (Asc)
- Calculate Running Total of HH
- Filter for Running Total <= 10000
- Clean-up fields for comparison
First pass was a a bit long... found a way to reduce the number of steps with the transpose... just wish I came up with it more quickly.
