Challenge #323: Analyze books Availabilities

[Qiu]

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

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

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]

Summer Reading List!

Spoiler

[mmontgomery]

Challenge #323

Spoiler

[Kenda]

Spoiler

[MuralidharAreti]

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

[Luke_C]

Spoiler

[PhilipMannering]

Solution attached,

Spoiler

[joelmiller66]

Bookstores still a thing??

Spoiler

[TonyAndriani]

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.

[mnmemilymnm]

I love the multirow formula tool!

Spoiler