Cloud Quest #11: Filtering Sports News

[prabhakaran5]

Spoiler

[mshishido]

here it is

[ggruccio]

Fun and easy!

Spoiler

[TonyaS]

This is what happens when I do not take any hints, it may be ugly but it does the job. :) 
And I created an App in App Builder for extra credit. 

Spoiler

[mceleavey]

Nice and straightforward, but ensure you make the necessary bits and pieces dynamic.

Spoiler

I first filtered down to those records containing "Sports" in the section column, then created the day of the week using DateTimeFormat(left([pub_date],10),"%A") in a formula.
I then took one stream into a Sum tool and counted the number of day occurrences, sampled the first one sorted by number descending, this gave me my first answer, then joined back on Day.
From there I made the "keywords" and "headline" columns uppercase and filtered for football. Then it was a simple summarise and a formula for the statement using those dynamic elements of count and day.

M.

[Shelbey]

Spoiler

[Smatthias]

Spoiler

SPOILER

Filtern for football, then parsed the word football out, so I could count it,the rest is simple math and a string.Quest11_matthias

[tshih18]

Spoiler

 

[patrick_digan]

Spoiler

[smurfitt]

Hi Please find my solution attached,  I believe the word football appears more times that the solution states, the solution seems to have the number of articles with the word football rather than the actual number of times that football appears..  I was able to match the solution, but added the correct to the end of the output..  

Let me know if I missed something,   

Thank you