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 #225: How Long Has It Been?

13 - Pulsar
13 - Pulsar

I had the time of my life solving this challenge! (I did not want to know how many hours I have been alive, but I know now)

Spoiler
cplewis90_0-1595292133943.png

 

16 - Nebula
16 - Nebula
Spoiler
1 %Love% reference shortcuts
2 I like that the data cleansing tool can now remove null columns
3 Annoying that DateTimeDiff had all the units built in except weeks?

patrick_digan_0-1595293028925.png

 

 
8 - Asteroid
Spoiler
2020-07-20 21_35_36-Greenshot.png
11 - Bolide
Spoiler
PaulFound_0-1595312911393.png

 

12 - Quasar
Spoiler
Challenge #225.PNG

Alteryx
Alteryx

I have used the floor function for the weeks instead of the expected ceiling used in the provided output. It seems to me that the numbers should reflect the whole number of time past and it should not be rounded upwards. This is the standard behaviour of the DateTimeDiff function.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Solutions Engineer
Alteryx
12 - Quasar

my solution

8 - Asteroid

I could see lot of way we can drive this challenge. I prefer the the simplest waych_225.PNG

Alteryx Certified Partner
Alteryx Certified Partner

Nice and quick one 🙂

10 - Fireball

Nice and easy 🙂

 

Spoiler
hanykowska_0-1595344646131.pnghanykowska_1-1595344665877.png

hanykowska_2-1595344684441.png