Challenge #323: Analyze books Availabilities

[Dlawless610]

Here is my solution. 

 

[lwolfie]

Nice Monday Challenge

[Bobbyt23]

Good challenge to get the dates in the same format as the output.

[cmoussa]

[Bennu]

Very nice challenge @Qiu , thank you!  I've submitted a WC idea with similar concepts.  Hopefully we will see it published eventually.

I think there's a minor sort inaccuracy in the output included in the Start file that the reasons appear in the wrong order in which they occur but it doesn't affect the results in a noticeable way unless you attempt to reconcile all the values to the ones in the output file included.

Spoiler

[Qiu]

@Bennu 
Thank you for your kind words.

[clairesteen]

Two approaches depending on the output requirement.

The first gives total unavailable days based on Book, Reason and Date Count (works well with a stacked bar chart).

The second looks solely at the date to achieve the consecutive days, noting that concatenation of reason can make it difficult to chart the data behaviour.

[BransonJamesFarley]

Went a little crazy with the select records tools..... 

Spoiler

 

[i-godz]

Spoiler

[Minanashat]