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 #230: Take a Look, It's in a Book!

dsmdavid
11 - Bolide

Spent the most time getting the reporting just right -- why header and footer are not showing in png, html, pptx but are in pdf?

 

Spoiler
dsmdavid_0-1598559854458.png

 

dsmdavid_1-1598559749560.png

 

 

CKent
6 - Meteoroid

Enjoyed playing w/ the Reporting Tools!

 

naresh5315
7 - Meteor

My solution: Workflow

Spoiler
naresh5315_0-1598591684907.png

 

My solution: Chart

Spoiler
naresh5315_1-1598591712516.png

 

coracai
8 - Asteroid

Another one down. 

hamza_khan
7 - Meteor

Considering that I am not a book worm, I made my workflow look like one.

PriyankaaJ
7 - Meteor

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.

 

Spoiler
PriyankaaJ_0-1598659899692.png

 

RichoBsJ
11 - Bolide

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...

 

Spoiler
Graph:

graph.png

Table:

table.png
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1598803105495.png

 

dlopez13
7 - Meteor

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.  

Spoiler
dlopez13_2-1598826139365.png



 

mbogusz
9 - Comet
Spoiler
2020-08-31 08_26_36-Greenshot.pngEngine_18192_561dc376cb01491ebd3b6033a234610d_.png