Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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.
