Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #68: Elapsed Classroom Times

minam
7 - Meteor

Easy one!

VizChic
11 - Bolide

fg AA soln 68

BenFr
Alteryx
Alteryx

 

Spoiler
BenFr_0-1627641096421.png

 

 

 

kcfuiks
8 - Asteroid

Attached Solution.

Shelbey
Alteryx
Alteryx
Spoiler
Shelbey_1-1628779595319.png

 

Ncardenas
8 - Asteroid

Interesting challenge.

My solution:

1. Formula Tool: PedLeft function to create consistency and comparability amongst the start/end times.

2. DateTime Tool: Convert string to date format following the DateTime Function documenation.

https://help.alteryx.com/20213/designer/datetime-functions

4. Formula Tool: IF statement to find if time exists for class and DateTimeDiff to compute elapsed time.

 

Spoiler
Ncajamarca_0-1629324849654.png

 

binay2448
11 - Bolide

My Solution...

lolcott
7 - Meteor
Spoiler
lolcott_0-1629494170129.png

 

MatthewBr
Alteryx Alumni (Retired)

I probably could have done this in fewer steps but wanted to work this out from a logical sequence. 

 

Matt

psampaio005
8 - Asteroid

Took a while and to many formulas to solve this one.

Spoiler
psampaio005_0-1629933732371.png