Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #438: Chronological Currency Balance

Spainey
9 - Comet

Nice and quick data manipulation.

Spoiler
Community Challenge 438 Solution.png

 

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-01-31 114909.png
arihant_jain
8 - Asteroid

Use transpose to convert all the columns into rows. Column headers are in standard Alteryx date-format (leverage it) and Cross tab again to put data back into original state. 

Solution.png

TomashevskiiVladimir
8 - Asteroid

438.png

DeepakPoojary
7 - Meteor

Solved!

SteveY02
8 - Asteroid

Done.

Just using pivot to solve this quiz, no nessary to transfer date format.

CeliaC_Silje
8 - Asteroid

Surprised to find out that without changing to date type, sorting the field under string type still works as expected 😯

Spoiler
challenge438challenge438
Daniel_Homola
8 - Asteroid

Solved!

DanielG
12 - Quasar

Solved

Saranya1995
8 - Asteroid

Here is my solution!