Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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 #323: Analyze books Availabilities

nkinsey
8 - Asteroid
‎07-18-2022 09:59 PM
Spoiler
nkinsey_0-1658206786103.png

 

challenge_323_nkinsey_solution.yxmd
Reply
0 Likes
MilindG
12 - Quasar
‎07-21-2022 05:52 AM
Spoiler
MilindG_0-1658407916519.png

 

SOlution 323.yxmd
Reply
0 Likes
sgreenough
8 - Asteroid
‎07-21-2022 08:08 AM

Solved!

Challenge_323_start_file.yxmd
Reply
0 Likes
dYoast
11 - Bolide
‎08-05-2022 12:50 PM

Same results, but a different order.

Spoiler
dYoast_0-1659729021057.png

 

MyResultsChallenge323.yxmd
Reply
0 Likes
rmassambane
11 - Bolide
‎08-05-2022 06:27 PM

323

Challenge_323.yxzp
Reply
0 Likes
vnicoletgregoire
8 - Asteroid
‎08-15-2022 10:37 AM
Spoiler
vnicoletgregoire_0-1660585011058.png

 

Challenge_323_start_file.yxzp
Reply
0 Likes
lkim524
8 - Asteroid
‎08-23-2022 12:18 PM

improved upon the solution by having the dates in ascending order and the reason for the book unavailability in the same order as the days.  struggled a bit on how to group the data into consecutive days groups and ended up using the datetimediff function.

Challenge_323_solve.yxmd
Reply
0 Likes
ggruccio
ACE Emeritus
ACE Emeritus
‎08-24-2022 11:26 AM

My Reasons seem to be in the reverse order of what is presented, but appear to be correct.

 

Spoiler
ggruccio_0-1661365556743.png

 

Challenge_323_gg_finish.yxmd
Reply
0 Likes
Abiramm1
8 - Asteroid
‎08-31-2022 01:17 AM

Not knowing proper datetime syntax means I have to use lots of DateTime tools :)

 

Spoiler
Abiramm1_0-1661933844299.png

 

Weekly challenge 323 solution.yxzp
Reply
0 Likes
grazitti_sapna
17 - Castor
‎08-31-2022 05:09 AM

grazitti_sapna_0-1661947770103.png

 

Sapna Gupta
Challenge_323_start_file.yxmd
Reply
0 Likes
Live Weekly Challenge