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.
alteryx Community

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #87: Losing Daylight

7 - Meteor

The first time I did it I used a reflexive join - it's much better with the Multi-Row Formula Tool! I'm glad the challenge helped me learn something new.

5 - Atom

i think this works..

Spoiler
17 - Castor

It's been awhile, what with work getting in the way.

Right, this is probably exactly the same as other solutions but here goes:

Spoiler
I first used the date parser to convert the sunrise and sunset times. I then used a datetimediff() to determine the length of the day. I then used a multi-row formula to determine the difference in day length from one day to the next, used a separate stream into a summary tool to determine the overall total of minutes different and unioned the streams. Fairly straightforward:

5 - Atom

Here goes to the first challenge :-) and hopefully many more to come

-->Updated file has the sum of difference, which was missing from the first  :)

ACE Emeritus

Working my way backwards in time ...

Spoiler
9 - Comet

Took me quite some time to figure out the proper syntax for the AM/PM identifier, as I did all the formatting in the formula tool.

Spoiler
8 - Asteroid

My solution is not as elegant as the majority that are here, however it should be dynamic enough to work fine with the next months data :) specifically changing the September Total to October Total.

15 - Aurora

A nice one to get the brain working, I wanted the datetime tool to be more flexible in accepting am|pm and outputting as 24hr...sadly it was not therefore more work for me!  @Ned can this be a thing?

Spoiler
17 - Castor

Not sure if this is relevant, but there's a conversion for a 24 hour clock format which is datetimeformat(<field>,"%H"). This should give you 00 to 23 hours.

5 - Atom
Spoiler

I converted everything to Alteryx Date format, so that we can also explore the result set in other tools (e.g. Tableau)