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 #300: Where is the party?

danbostrom
8 - Asteroid

 

 

vitoriatnrio
6 - Meteoroid

Check it out!

Justin_Bell
7 - Meteor

Spent some time trying to figure out how to trim off the first two characters of a field, "right([Code_name], Length([Code_name])-2)" seems counter-intuitive so if anyone can explain that better it would be fantastic.

 

Beyond that, formula to *count* new years days made the most sense because then you could filter between 2 and 0 for the output.

 

Cheers

Dibas98
8 - Asteroid

Solution

GaneshS_Naik
8 - Asteroid

Spoiler

DHATHRI
7 - Meteor

               

oscar_leeper_wf
7 - Meteor
Spoiler
Challenge_300_Spoiler.png
katherinexing
6 - Meteoroid

Attched

kcollazos
6 - Meteoroid

Great practice for the datathon! 

lars3033
6 - Meteoroid

Substring([Code_name], 2)

 

Be careful, because Alteryx uses zero-base indexing ... which means that starting index value of 2 actually starts with the third character