Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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

Challenge #425: Weekly Allowance Distribution

fesrimo
8 - Asteroid

 

I believe there is an error in this lab.

The solution we are considering involves carrying forward an additional week of travel expenses amounting to $150. However, the announcement specified the total amount of money spent after the four weeks.

Therefore, the correct amount for Row #5 should be $400, not $250.

Winniechen1103
5 - Atom

spoilerspoiler

nhardin
7 - Meteor
Spoiler
Screenshot_solution_425.png
AYXAcademy
Alteryx
Alteryx

Thank you, everyone!

Actually, there was an inconsistency in the output which I've corrected.

fesrimo
8 - Asteroid

Awesome!

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
Garrett_Stoker
8 - Asteroid
Spoiler
Screenshot 2024-05-20 151354.png
olga_strubbe
11 - Bolide

Thank you, @Qiu and @AYXAcademy !

This was an interesting challenge that can offer a variety of approaches/methods in how to come with the solution. 

I used an app where a user can enter the weekly spend from $1-$1,000 to calculate the balance left if any. 

I think it will be neat to take it a level further and build an iterative macro where a user can specify a number of weeks in addition to the amount of the weekly spend.   If anyone is up to building an iterative macro on this, please share!

My app: 

2024-05-20_16-27-45.png

 

2024-05-20_16-28-17.png

Qiu
21 - Polaris
21 - Polaris

All

I think I was wrong for the last person. I need to check

thank for poing it out.

LindonB
11 - Bolide
Spoiler
Capture.PNG