Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
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
A solution to last week's challenge can be found here!
In case you missed it, the Oscars awards ceremony was held last night. Also, in case you missed it, we made it easy to get caught up on the nominees and the winners of each award category!
Using the provided dataset and look-up table to create an app to allow an end-user to select an award category. Render the result as .pcxml to reveal the winner of that category!
SPOILER ALERT: This challenge contains spoilers...if you want to read up on the award ceremony, it would behoove you to to do so before completing this challenge!
Fun Fact: Oscars weigh 8.5 lb and stand 13.5 inches tall!
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
Are you enjoying the new Weekly Challenge page? We hope you've had a chance to read our blog post explaining the exciting new features we've introduced in this latest version. We'd love to hear your thoughts, so please leave us a comment with your feedback!
This week's challenge, created by Motoi Tokimatsu, will test your RegEx skills! Thank you, @Tokimatsu , for presenting this intriguing task.
Have you heard about the 850 words of Charles Kay Ogden's Basic English? (In this context, the acronym BASIC stands for British American Scientific International Commercial.) In his book published in 1930, Basic English: A General Introduction with Rules and Grammar, he created a list of about 850 words to form the core vocabulary of Basic English. Basic English aims to create an easier and more efficient form of English for international communication, particularly for those learning English as a second language. The reduced vocabulary is designed to cover most everyday situations and needs without the complexity of the full English language.
Your tasks for this challenge include:
Download the data from the URL provided.
List the words (around 850)
Create an index with the first letter of each word.
Calculate the number of words that start with each letter of the alphabet.
In this challenge, the Replace and Tokenize functions in RegEx will be your best friends.
Need a refresher? Review the following lessons in Academy to gear up:
Replacing Data with RegEx
Splitting Data with RegEx
Good luck!
... View more
A solution for last week's challenge has been posted here in both video and workflow forms!
This week's Challenge lets you get crafty! Create an app to allow a user to search a list of craft canned beers by state of origin or beer style. Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles. Feel free to customize the app as you see fit!
... View more
A solution to last week’s challenge can be found here. Source: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.html
Every year whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an outstanding 12,000 miles round trip!
Use the data sets below to analyze migration movements for different whale species.
The file Whale_Migration_Data contains a list of whales whose migration patterns have been tracked from 2001-2003, and the total kilometers each whale swam on each day of their migration.
The file Whale_Pods contains a list of whale ids and pod ids, which indicates the pod each whale belongs to.
The file Whale_Species contains information about the whale species of each pod.
Find the total number of kilometers each pod swam for migration for each year, then find the average number of kilometers each whale in that pod swam (total kilometers / number of whales in the pod). Then, find the pod with the highest average kilometers swam per whale for each species for each year.
... View more