Alteryx Academy

Hello, Community!   A solution to last week’s challenge can be found here.   This challenge was created by Desmond Turner. Thanks, @Desmond , for submitting your idea for this Weekly Challenge!   With the US football season now underway, it is the perfect time to dive into some football data. Over the years, the running back position in the National Football League (NFL) has seen a decline in value, driven by the league's shift towards a pass-heavy game. But does the data back this up? Use the provided dataset covering all plays from 2008 to 2019 to examine how the balance between running and passing has shifted over time.   Your challenge is to complete the following tasks: Calculate the total yards gained from run and pass plays each year. Determine the percentage of total yards gained attributed to running plays. Identify the top three teams that have leaned most heavily on the running game throughout this period.   Good luck, and happy football season!   Need a refresher? Review the following lessons in Academy to gear up. Introduction to Macros in Designer Types of Macros in Designer Macro Interface Elements Creating an Iterative Macro   Source: https://www.kaggle.com/datasets/maxhorowitz/nflplaybyplay2009to2016?select=NFL+Play+by+Play+2009-2018+%28v5%29.csv   Alteryx Academy ... View more

Last week's solution has been posted HERE.   A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if a course ends at 16:30, he would like it to show as 4:30. He also wants to know what the elapsed time is between the two fields mentioned above. How long is each course? Minutes will be the time unit measured.   ... View more

A solution to last week's challenge can be found here.    This week's challenge was submitted by @wwatson  - Thank you for your submission!   For this week's challenge, you are the skipper of a large container ship destined for Belfast harbour. You must navigate through the exact centre of the navigation channel due to the large draft of your ship. The origin - current position of your ship, the destination and the locations of the channel marker buoys are provided.   Plot the marker buoys as lines showing the left and right buoys, and the route through centre of the buoys. Also calculate the length of the route through the channel from your origin to the destination in miles. Create a report snippet to show the route and distance. ... View more

Here is a new challenge for this week. The link to the solution for last week’s challenge is HERE. The use case: We received some text data and that includes an embedded line-feed character. The objective is to remove the new line character, convert the date-time string to a date-time formatted field and then do some renaming per the sample output. Good luck, I look forward to your feedback. ... View more

A solution to last week's challenge can be found here.  Source: https://www.forbes.com/sites/jimwang/2020/02/17/how-to-write-a-personal-check/#558fbbd56818   This week's challenge picks up where we left-off last week. As it turns out, the values we formatted last week were prices on a contract. It is common in many legal documents to write out the values displayed as an additional redundancy to ensure everyone is on the same page and there are no typos. Maybe we should do the same...   Convert the values in the table into written form. (e.g. 9612001.00 > nine million six hundred twelve thousand one dollars and no cents) ... View more