Challenge #192: Crane Leasing

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.

Bob the Builder with Crane.jpg

Source: GIPHY

challenge_192_start_file.yxmd

challenge_192_solution.yxmd

Parse

Join

Preparation

Data Analysis

Intermediate

Data Preparation

Core

Transform

Accepted answers

All comments

Shahbaz_analyst

Spoiler

Interesting thing I learnt about the generate rows tool in this challenge. If your newly created field is a datetime type and your end date field is just a date type the generated rows won't include the last date even if your expression says new field <= end date field. I assume this is to do with the time component not lining up with the end date but it took me a while to figure out why I was getting different amounts of rows using the generate rows function when i updated a field vs creating a new field.

challenge_192_start_file.yxmd

gaoa

My solution:

Spoiler

challenge_192_start_file_gaoa.yxmd

m-wolters

My solution

Spoiler

challenge_192_start_file.yxmd

Adrien_Sourdille

Alt 192.png

challenge_192_start_file.yxmd

kristiadiuisan

Spoiler

challenge_192_start_file edit1.yxmd

RobbieA

My solution to 192:

challenge_192_start_RA.yxmd

elaineyuan

I need more practice with the Generate Rows tool. 😅

Spoiler

challenge_192_elaine_yuan.yxmd

zmatipano

Spoiler

my solution

challenge_192_Zivai Solution.yxmd

hharris0411

Spoiler

challenge 192.yxmd

Shifty

I am really enjoying the unique tool at the moment. :Unique:

Spoiler

challenge_192_sr.yxmd

Carolyn

Completed!

AndrewHoData

I hadn't realised there was a function called

Spoiler

DateTimeParse which could parse date based on format. Instead I wrote out a long ToString RegexReplace statement to achieve the same thing before realising such a elegant solution!