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 #117: Credit/Debit Midpoints

Ladarthure
14 - Magnetar
14 - Magnetar

my solution!

AngelosPachis
16 - Nebula

Challenge #117 solved

 

Spoiler
Annotation 2020-06-04 184153.png

 

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 117 is done!

 

Spoiler
image.png
AhmadAlkherbawy
7 - Meteor
Spoiler
solution.png

 

JennyMartin
9 - Comet
Spoiler
AWC117.PNG

Did a lot of faffing not knowing how to tackle this challenge, but got there in the end. A fantastic learning opportunity!

JethroChen
10 - Fireball
Spoiler
challenge_117_jc.PNG
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

Spoiler
My first workflow is very many tools, so I tried 2nd challenge.

AkimasaKajitani_0-1601556165843.png

 

I tried to new workflow.

I use Dynamic Replace tool in Batch Macro.

Spoiler
Batch Macro
AkimasaKajitani_0-1601718956634.png
Workflow
AkimasaKajitani_1-1601719029744.png

 

 

Qiu
20 - Arcturus
20 - Arcturus

Learned something about Math.

Spoiler
en-117.PNG
KilianL
Alteryx Alumni (Retired)

Nice little problem to solve!

I went for a simple formula to identify the midpoints. Some prep around and it works.

 

Spoiler

solution idea:

1. sum all
2. running total
3. if running total = sum - running total - next transaction

117 - midpoints prep - Kilian.png