Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASpent the most time getting the reporting just right -- why header and footer are not showing in png, html, pptx but are in pdf?
As my colleague pointed it out, records with multiple authors are separated by an "and" and a "with". So there is a slight difference in the total number of weeks and the total count of books.
Hi! Nice challenge! Here my solution 🙂
By the way, the provided solution is inaccurate; for example, James Patterson should sum 200 weeks instead of 195, because the provided solution hasn't taken into account the 5 weeks of the books that have a "with" word in the "author" field...
Doesn't look like the recommended output accounted for this, but I applied fuzzy matching to the split author names to account for inconsistent formatting. It did result in a small increase to the data that made it into the chart.