Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #87: Losing Daylight

Highlighted
8 - Asteroid

Sharing my solution, thanks for the challenge!

 

Spoiler
Challenge_87_edavilac.PNG
Highlighted
7 - Meteor

  

Highlighted
8 - Asteroid

Hi,

 

Sharing my solution.

 

Spoiler
Challenge_87_Emil_Kos.png
Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590155383544.png

 

Highlighted
8 - Asteroid

RegEx is your friend, as is also DateTimeParse()

 

Spoiler

izamryan_0-1590169063036.png

 

For this one I used two inline RegEx tools:
(\d:\d{2}.\w{2})
this slices out the stamp WITH the AM/PM.

I then used a Formula tool to convert the string into DateTime format so we can do calculations
DateTimeParse([Sunrise_time],"%I:%M %p")
the %p takes care of the AM/PM and
DateTimeDiff([Sunset_time],[Sunrise_time],"minutes")
takes care of the calculation of minutes, without necessitating complex logic to account for the 24-hour clock

Calculating the delta between the days seems a bit unintuitive, so I forced it with this inline IF:
iif([Row-1:Day Length (minutes)]-[Day Length (minutes)]>0,([Row-1:Day Length (minutes)]-[Day Length (minutes)])*-1,null())

I then used a Summary tool, Text Input tool and an Append Fields tool to mash up the last row to show the total difference over the whole month.

Overall it feels a little clumsy, especially the multi-row formula. But I approximated the solution (albeit I left mine with extraneous zero's or the seconds!)
Highlighted
6 - Meteoroid

Thank you for this stimulation exercise. Attached herein solution using the summarize tool.

Highlighted
11 - Bolide
Spoiler
 
Highlighted
8 - Asteroid

My solution attached. In comparison to others I have similar steps except at the end I have used ABSOLUTE values vs -ve variance. 

 

this was fun!!

Highlighted
7 - Meteor
Spoiler
Alteryx.PNG

Highlighted
7 - Meteor

my solution