This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
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.
Great practice parsing and manipulating dates with Alteryx!
Yes we can!!!
My DateTime field ended up being in String when I applied the formula initially and was getting so close yet no cigar till I debugged and switched the format.
Got a slightly different result until I looked at the data and realized that a crane could be both leased and something else on a given day.