topic Re: Challenge #323: Analyze books Availabilities in Weekly Challenges

Challenge #323: Analyze books Availabilities

Qiu — Tue, 13 Sep 2022 18:43:18 GMT

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

Re: Challenge #323: Analyze books Availabilities

Aaron_Harter — Mon, 13 Jun 2022 17:13:54 GMT

Summer Reading List!

Re: Challenge #323: Analyze books Availabilities

mmontgomery — Mon, 13 Jun 2022 17:13:58 GMT

Challenge #323

Re: Challenge #323: Analyze books Availabilities

Kenda — Mon, 13 Jun 2022 17:26:13 GMT

Re: Challenge #323: Analyze books Availabilities

MuralidharAreti — Mon, 13 Jun 2022 17:28:54 GMT

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 :)

Re: Challenge #323: Analyze books Availabilities

Luke_C — Mon, 13 Jun 2022 17:48:03 GMT

Re: Challenge #323: Analyze books Availabilities

philipmannering — Mon, 13 Jun 2022 18:01:04 GMT

Solution attached,

Re: Challenge #323: Analyze books Availabilities

joelmiller66 — Mon, 13 Jun 2022 18:05:57 GMT

Bookstores still a thing??

Re: Challenge #323: Analyze books Availabilities

TonyAndriani — Mon, 13 Jun 2022 18:21:59 GMT

Here's my solution

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.

Re: Challenge #323: Analyze books Availabilities

mnmemilymnm — Mon, 13 Jun 2022 18:53:13 GMT

I love the multirow formula tool!

Re: Challenge #323: Analyze books Availabilities

luisrifp — Mon, 13 Jun 2022 19:29:02 GMT

Nice!

Re: Challenge #323: Analyze books Availabilities

CharlotteGuy — Mon, 13 Jun 2022 20:26:09 GMT

Chris

Re: Challenge #323: Analyze books Availabilities

opoleleyeva — Tue, 14 Jun 2022 00:25:29 GMT

Probably not the prettiest of solutions, but works just the same

Re: Challenge #323: Analyze books Availabilities

Powerhouse_21 — Tue, 14 Jun 2022 02:16:40 GMT

Re: Challenge #323: Analyze books Availabilities

RolandSchubert — Tue, 14 Jun 2022 04:31:10 GMT

Re: Challenge #323: Analyze books Availabilities

AkimasaKajitani — Tue, 14 Jun 2022 05:08:50 GMT

My solution.

I can't make match in the date order.

Re: Challenge #323: Analyze books Availabilities

Alessio — Tue, 14 Jun 2022 07:48:20 GMT

Spoiler

Below my solution

Re: Challenge #323: Analyze books Availabilities

CHarrison — Tue, 14 Jun 2022 08:20:34 GMT

My solution :)

Re: Challenge #323: Analyze books Availabilities

Lalitjeee — Tue, 14 Jun 2022 09:41:59 GMT

My Solution :)

Re: Challenge #323: Analyze books Availabilities

ahsanaali — Tue, 14 Jun 2022 10:22:48 GMT