We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #323: Analyze books Availabilities

Qiu
19 - Altair
19 - Altair

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

 

A bookstore owner would like to analyze why some books were unavailable.

image_323.png

 

The Dataset reflects the daily slip records of the book available by title, date, and reason why they are or aren’t available. Note that the column “Availability” provides the number of books available for the given date.

 

For this challenge, help the store owner find out how many consecutive days a book was unavailable and the reason(s) why.

 

Hints
• Start by flagging the day a book is unavailable
• Group by consecutive days of availability by book so you can filter the unavailable books
• Pick the first and last day of unavailability and count the number of consecutive days unavailable and the reasons
• Pull the first and last date of availability

Aaron_Harter
11 - Bolide

Summer Reading List!

Spoiler
0.jpg
mmontgomery
8 - Asteroid

Challenge #323

 

Spoiler
mmontgomery_0-1655140425638.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler

Kenda_3-1655141165571.png

 

MuralidharAreti
7 - Meteor

I took a few extra steps including converting the date field to an ISO standard (a format that Alteryx also likes!) Maybe it was unnecessary but it helped my peace of mind :) 

 

Spoiler
MuralidharAreti_0-1655141307563.png

 

Luke_C
16 - Nebula
Spoiler
Luke_C_0-1655142472005.png

 

PhilipMannering
15 - Aurora
15 - Aurora

Solution attached,

 

Spoiler
PhilipMannering_0-1655143231157.png

 

joelmiller66
8 - Asteroid

Bookstores still a thing??

bookstore.jpg

Spoiler
323 screenshot.jpg
TonyAndriani
8 - Asteroid

Here's my solution

Spoiler
Same result, but organized a bit differently. Grouped by Title and sorted by Start Date in chronological (not dictionary) order. Also listed reasons in order from first to last day instead of last to first day.

TonyAndriani_0-1655144445686.png

 

mnmemilymnm
8 - Asteroid

I love the multirow formula tool!

 

Spoiler
mnmemilymnm_0-1655146352381.png