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 #471: Find the Best Job Offer

AYXAcademy
Alteryx
Alteryx

Full Width - WC banner.svg

 

Hello Community Members,

 

A solution to last week’s challenge can be found here. 

 

This challenge was submitted by Griffin Welsh @griffinwelsh. Thank you, Griffin, for this great challenge!

Job hunting today takes a lot of time and effort. You are not only sifting through hundreds of job postings but also crafting tailored resumes, writing cover letters, following up with recruiters, and networking to land the perfect role.

Once the offers start coming in, how do you decide which job is truly the best?

Your challenge is to compare multiple job offers based on the costs you will have to commute to work. You have two datasets:

  • Job Details Text Input: Job details from six companies you received offers from.
  • Constants Text Input: Information about fuel prices, car maintenance costs, miles per gallon, and your home location.

 

Your tasks are the following:

 

  • Calculate your annual fuel cost and vehicle maintenance cost for each job. Consider the following for this calculation:
  • Travel time to office
  • Daily fuel cost
  • Vehicle maintenance cost
  • How many days you will be in the office

 

  • Calculate your annual travel time (coming to and from work).

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Good luck!

The Academy Team

Download Start File

 

Download Solution File

DylanBell
9 - Comet

I love spatial challenges, this was very quick and fun to do! Thank you for another fun challenge :)


Bulien
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
471.jpg
Pilsner
11 - Bolide

Fun Challenge! Spent longer than I would like to admit in the formula tool. After typing it out again fresh, I got the right answer, so I must have made a typo somewhere. My solution:

Spoiler

  

471.png

 

JBevan89
8 - Asteroid
Spoiler
JB_C471.png


I did part 2 first, and then used the distances in part 2 to link back to part 1 - typical me doing things in my own order😎

Bobbyt23
12 - Quasar

Initially got distracted with the different days/week options but enjoyed that challenge.

Spoiler
image.png
alacoume
9 - Comet

My solution :

 

Spoiler
Challenge_471.jpg
balajilolla2
10 - Fireball
Spoiler
Solution Attached

Screenshot 2025-04-07 084639.png
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
ggruccio
ACE Emeritus
ACE Emeritus

Almost everything driven by a Formula Tool.

 

Spoiler
Screenshot 2025-04-07 114938.png