A solution to last week's challenge has been posted here.
This week's challenge comes to you from ACE @Treyson - Thank you for your contribution!
Determine the profit margin for your company based on the number of quarters they have been a customer of yours. Read the directions carefully and use the hints as needed.
... View more
A solution to last week's challenge can be found here!
In this week’s challenge, a handyman and local television star needs your assistance assessing his business using date/time analyses.
Bob, whose profession had been builder, decided to transition his business towards leasing construction equipment. Among other equipment, he has two cranes that he has been leasing for a while. He wants to get a better idea how his crane leasing business has been going.
Create a workflow that will show how many days both of his cranes have been leased at the same time during the years 2016-2018, the only years where he has a full set of data for both cranes.
Source: GIPHY
... View more
The link to the solution for last challenge #37 is HERE.
One of the powers of Alteryx is to be able to batch processes without the need to write scripts of use complicated code. A single output tool can be configured to generate many output files.
Use Case: A company needs to blend data from three sources and generate an output file for each product - region combination, a total of 15 output files.
Objective: Create a cross join between the Product Group, Region Reference and Data tables to produce 15 unique CSV Data files. Please note that only 1 output tool should be leveraged in your solution.
Thanks to all that are playing along!
... View more
A solution to last week’s challenge can be found here.
Because having a reliable electricity source is important to many people, we tend to notice when the power goes out! While we might expect service outages during severe weather events and other natural disasters, sometimes the culprit is... fluffier and cuter, or slithers.
Using the provided dataset, find out: • How many outage events can we attribute to animals? List the culprits with the count of events in descending order.
Hint Use the animals listed in the "Operative" field and information from the "Article Title" field to replace values of "Animal" with the actual animals.
Note
All animal types present in this dataset are included in the "Operative" column.
... View more
A solution to last week's challenge can be found here.
If you're familiar with the Formula tool in Designer, you know that there aren't many things you can't do with it. But just because you can do something doesn't mean that you should. There are some tasks that can get a little repetitive when you have to do them over and over again. In those instances it can be more efficient to think about ways to make the process a little more dynamic. This also serves you well as you begin automating processes because it can keep workflows from breaking when datasets change.
For this week's challenge, we want to perform a simple calculation: divide each month's Tax value by its Cost value to find the Percentage. Since there are almost always multiple ways to accomplish the same task, go for a double dip and find two solutions to arrive at the final output.
... View more
