Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #192: Crane Leasing

aman_goyal
Asteroide

Bit difficult Challenge !! check my solution

Mengdee
Asteroide

hmm mines a bit ugly but got the job done

rcor
Asteroide

 Solved!

 

Spoiler
192.PNG

 

brig
Asteroide
Spoiler
brig_0-1593283877459.png

 

At first I was overcomplicating it with a multi row formula....

paulfound
Bólido
Spoiler
PaulFound_0-1594820558685.png

 

wwatson
Cuásar

My solution. The tricky bit was the leases that crossed 2015-2016 or 2018-2019.

 

Nice one.

kinjalshah
Átomo

Here is my solution!!

Sashikumar
Asteroide

Good.

Spoiler
ch192.PNG
jamielaird
Magnetar

Here's my solution

 

Spoiler
jamielaird_0-1600631938111.png

 

JethroChen
Bola de fuego
Spoiler
challenge_192_jc.PNG