Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #230: Take a Look, It's in a Book!

Highlighted
Alteryx Partner

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

 

 

Highlighted
Alteryx Partner

Enjoyed playing w/ the Reporting Tools!

 

Highlighted
7 - Meteor

My solution: Workflow

Spoiler
naresh5315_0-1598591684907.png

 

My solution: Chart

Spoiler
naresh5315_1-1598591712516.png

 

Highlighted
8 - Asteroid

Another one down. 

Highlighted
7 - Meteor

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

Highlighted
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

 

Highlighted
8 - Asteroid

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
Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1598803105495.png

 

Highlighted
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



 

Highlighted
8 - Asteroid
Spoiler
2020-08-31 08_26_36-Greenshot.pngEngine_18192_561dc376cb01491ebd3b6033a234610d_.png