Alteryx Academy

Hi Community,   We posted the solution JSON file to Cloud Quest #16. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!     Let’s dive into this week's quest!   Download the provided JSON file containing your starting data and workflow files. Upload the provided Cloud Quest 17 Start.json file into your Analytics Cloud library. All necessary datasets are contained within Text Input tools in the workflow. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.   Scenario:   Marie lives in Toronto, Canada. Every spring, as soon as the weather permits it, she rides her bike to work. Her office is about 15 km away from her home if she drives her car, and a 12 km ride if she bikes.   On Tuesdays and Thursdays, Marie works remotely. On Mondays, Wednesdays, and Fridays, she has to go to into the office. If the temperature gets up to 28 degrees Celsius, she drives to work.   Use the dataset to determine: - How many days did Marie bike and drive in April, May, and June 2021? - How many kilometers did Marie bike and drive in April, May, and June 2021?   Use the “Max Temperature” information provided in the dataset. Note: If the Max Temperature is NULL, assume it is a driving day.   ** Data source: https://climate.weather.gc.ca/climate_data/daily_data_e.html?StationID=51459   A combination of the Filter, Summarize, and Formula tools should solve your problem, but not necessarily in this sequence.   If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connections in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file. Include your JSON file and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!       ... Mehr anzeigen

 The solution to last week's Challenge has been posted here!   We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you! This month we present the case of the hard-coded workflow.     Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.   The Case: A client’s co-worker has built a workflow that returns a date range between a selected Date (Date1) and the date (Date2) that is x days prior to Date1, as well as all the dates between Date1 and Date2.  The workflow (attached to this post) is great!  It returns all the information she needs for her analysis in the format she wants.  The problem?  Running the workflow requires a cumbersome amount of hard-coding values.  She needs to manually update a Filter tool to select her date range:  Ugh....I had to type this whole thing, and I have to change it every time I want to use a new set of dates!   and a Text Input tool to enter the number of days as a range (1 - x) prior to her selected date to find:  I had to type every one of these numbers! What if I wanted to return much more than 7 days?  There has to be a better way to get the data she wants!     Explanation of the Problem:  The client would like the ability to dynamically select date ranges and the number of days (e.g. 5, not as a range) preceding the selected date.  Can this be done?    Asset Description: The client has shared the workflow she uses, which includes a calendar selection macro (ClientWorkflow.yxzp).    Bonus Question: Is there a way for each date from the date range selected (Date1) to be processed, one at a time?   ... Mehr anzeigen

Hi Maveryx,   We posted the solution JSON file to Cloud Quest 15. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!     Let’s dive into this week's quest!   Download the provided JSON file containing your starting workflow. Upload the provided Cloud Quest 16 Start.json file into your Analytics Cloud library. All necessary datasets are contained within Text Input tools in the workflow.   For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.   Scenario:   NOTE: Designer Cloud Standard Mode is required to complete this quest.   You are working as a data analyst in the automotive industry. You need to build a process to validate vehicle identification numbers (VINs) to test for data quality issues across vehicle fleet data. The algorithm that validates VINs is explained in the Check-digit calculation section of the following wiki link.   http://en.wikipedia.org/wiki/Vehicle_identification_number   Your task is to take the VINs from the VIN List Input and create a new column for the check digit. The check digit is always the 9th character in the VIN. Compare the check digit with the calculated check digit value. If the two values do not match (and there was no error in the calculation), then there is a mistake in the VIN. Out of the six VINs provided, how many vehicles have a valid VIN?   The relevant lookup tables have been provided.   Hint: Use the function Mod([Sum_Product], 11) to compare against the VIN check digit as explained in the Wiki article.   A combination of the Summarize, Transpose, Join, Formula, Filter, and RegEx tools should solve your problem, but not necessarily in this sequence.   If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connections in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file. Include your JSON file and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!     ... Mehr anzeigen

Hi Community members,   A solution to last week’s challenge can be found here.   This two-part challenge was submitted by Guilherme Dias, @3I_ATLAS. Thank you, Guilherme, for your great submission!   In the previous challenge, you have already identified critical production trends and model behaviors for electric vehicles. Now, shift your focus to innovation and decline — two sides of product lifecycle in the EV industry.   In the second part of this challenge, you analyze which years saw surges of new model launches and which saw waves of production extinction. Reminder: Only include years from 2010 to 2024 in your analysis, as 2025 data is incomplete.   Here are the two tasks you need to accomplish:   Determine which two years had the most distinct new models launched and from which brands were these models launched. Identify the year with the highest number of distinct models that stopped being produced, relative to the prior year. Count each model that was produced in year Y but not in year Y+1 as “extinct,” even if it returns in later years.   You are provided with one dataset (the same dataset from part 1 of this challenge): Electric Vehicle Data – provides the model year, manufacturer (brand) and car model.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: https://catalog.data.gov/dataset/electric-vehicle-population-data   Download Start File   Download Solution File ... Mehr anzeigen

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by our ACE Carolyn Canterman (@Carolyn). Thank you, Carolyn for your submission!   The Sarbanes-Oxley Act of 2002 (SOX) is a U.S. federal law enacted to protect investors by improving the accuracy and reliability of corporate disclosures. Under SOX, companies must implement internal controls over financial reporting.   These controls are categorized as: Key Controls – considered critical for financial reporting and subject to stricter review Non-Key Controls – important, but with less scrutiny   Each SOX control requires: A Preparer, who performs the analysis. A Reviewer, who independently reviews the work.   Both the Preparer and Reviewer must sign off by entering their name and date. This sign-off process is logged as evidence of proper control execution.   You are an auditor reviewing the SOX Control Sign-Off Log for accuracy and compliance.   You will be provided with three input files: The SOX Control Sign Off Log, evidencing the Preparer and Reviewer sign off for each Control, for two different months. Information on the employees. List of issues that you are checking for.   Use the Issue Rule List to validate each Control entry. A control has an issue if it violates any of the following rules: Both Preparer and Reviewer must be present, and they must be different individuals. Sign-off dates must follow proper sequence: Both Preparer and Reviewer must have a date. Reviewer date must be within 5 days after the Preparer date (inclusive). Reviewer date cannot be before the Preparer date. If the SOX Control is marked as a Key Control, the Reviewer must be a manager.   Your Tasks   Task 1: For each Control in each Period, count how many issues are present according to the rules above. Note: If information is missing or unclear and you cannot determine whether there’s an issue, do not count it as an issue.   Task 2: Which Period had more total issues — March 2025 or April 2025?   Task 3: Task 3: Across both periods, which control had the most issues in total?   Bonus Task: Which person is associated with the most total issues across all controls and periods?   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Download Start File Download Solution File ... Mehr anzeigen