community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #106: How Long were the Lights On?

Meteoroid

My first challenge! I need to become more comfortable with time parsing still, but I made it work.

Looking forward to the next challenge!

Highlighted
Alteryx Partner
 
Alteryx Partner

This took longer than I wanted. I was able to to use DateTimeParse to parse the time, but couldn't create 24H time properly using DateTimeAdd without having a date as part of the field. I had to add today to the string before I could use it and then it was easy afterwards.

Asteroid

106.JPG

Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Asteroid

Complete

Pulsar
Pulsar
Spoiler
Converted the times into actual time fields, accounting for the AM/PM. Started down the path of using a MultiRow Formula tool,  followed by a DateTimeDiff to calculate the number of minutes. This wound up being a problem because some of the enter times, when updated to be after the previous exit times, were after the exit time. Didn't want to deal with those problems.

Soon realized that I could just generate the minutes in between the two times, and then count the unique ones per room.

Fun challenge!!
Alteryx Certified Partner

I started down to multirow formula route, then I realised I was making it way too complicated....so I changed tack and went for...

 

Spoiler
Weekly Challenge 106.png

 @LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

 

Alteryx Certified Partner

My solution.

 

Spoiler
Spoiler_Pic.JPG