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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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 #312: Hours, Minutes and Seconds

Qiu
19 - Altair
19 - Altair

A solution to last week’s challenge can be found here.

 

On daily basis, call centers are handling customers requests using a chat feature. In parallel, their analysts are checking data to report on their operators performance.Weekly Challenge Image 312.png

 

A data analyst in a major call center was responsible to report on their numbers by the end of the day. He wants to convert the time format from "HH:MM:SS" to "Hours Minutes Seconds", and his boss does not want any unnecessary information in the output. So meaning, no leading zeros and attribute should be removed if it is zero.

 

Using the data sets provided create an output with the format that the data analyst needs.

Aaron_Harter
11 - Bolide

Right on time!

Spoiler
0.png
atcodedog05
22 - Nova
22 - Nova

Here is my take on it.

 

Spoiler
atcodedog05_0-1648487243923.png

I am just solving this from muscle memory 😅. Since I had solved a similar usecase a while back😀

Thanks for the fun challenge @Qiu 


Cheers and Happy analyzing :)

David-Carnes
11 - Bolide

Even though this was a simple one, I still adhered to the principle of dumping or filtering out unneeded data as soon as possible.

 

Spoiler
DavidCarnes_0-1648487343813.png

 

Blake
12 - Quasar

How do clocks greet each other? 

Spoiler
They say hour are you doing?
Spoiler
312wc.png
PatrickW_
Alteryx
Alteryx

Alteryx: the time is now!

joelmiller66
8 - Asteroid
Spoiler
312 screenshot.png
binuacs
15 - Aurora
Spoiler
binuacs_0-1648491033863.png

 

TonyA
Alteryx Alumni (Retired)

There are a pile of ways of doing this. I think I can see what Qiu was looking for based on the format of the solution and his including a mapping table for the time units, so I tried to follow that.

Spoiler
TonyA_0-1648492629465.png

 

Watermark
8 - Asteroid

Feel like I was lazy and have too many tools, but I am pressed for time so just threw this together. 

 

Spoiler
MT Solution 312.jpg