Learn

 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?   ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!   A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.   Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!   You’ve been provided with two datasets: A certifications dataset containing certification records, each with its status (Expires or Expired) and the date. A team mapping dataset linking each participant to their respective team.   Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:   Only include certifications that are currently valid (status is Expires). Focus only on certifications with names that include Alteryx Designer or Server. Exclude any certifications that mention Cloud or Trifacta. Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.   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: Dataset generated by ChatGPT.   Download Start File Download Solution File  ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Erin Miller. Thank you, @Erin , for another great challenge!   According to Erin, someone who wins at Mario Kart seems to know every shortcut and trick, and it’s easy to assume they’re always choosing the perfect character and kart combo. But not anymore! We now have access to in-game data for every driver, kart/body, tire, and glider in Mario Kart 8 Deluxe.   Using the datasets provided, the mission is to identify the most optimal combinations that deliver the best overall racing performance.   What You Need to Do Compute the average value for each stat category (speed, acceleration, handling, etc.) across each individual dimension: driver, kart/body, tire, and glider. Determine the average stat values for every combination of driver, kart/body, tire, and glider. For example: What is the average speed for a specific driver when paired with a given kart, tire, and glider? For each combination, calculate a total weighted average using the provided weights table (or create your own!) to reflect the relative importance of each stat.   The final output should include each driver–kart–tire–glider combination, the corresponding average stat values, and a total weighted score.   Feeling a Little “Extra”? Use a macro to automate repetitive tasks (such as calculating averages).   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://www.kaggle.com/datasets/marlowspringmeier/mario-kart-8-deluxe-ingame-statistics   Download Start File   ... View more

Cozy up! Time for the Top Contributors November blog ... View more

Alteryx 10.1 includes new controls to make it easier to navigate around the canvas with large workflows.   ... View more