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

Qiu
21 - Polaris
21 - Polaris

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
11 - Bolide

Challenge #323

 

Spoiler
mmontgomery_0-1655140425638.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler

Kenda_3-1655141165571.png

 

MuralidharAreti
8 - Asteroid

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
17 - Castor
Spoiler
Luke_C_0-1655142472005.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1655143231157.png

 

joelmiller66
9 - Comet

Bookstores still a thing??

bookstore.jpg

Spoiler
323 screenshot.jpg
TonyAndriani
9 - Comet

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