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 #407: Single Biggest Lottery Winner

robert-headington
Asteroide

#407

martinson
Cometa

Attempt 1

mgaronson
Bólide
Saqueador
Challenge 407 Workflow Pic.png

  2 questions - number of one-winner jackpots and highest jackpot amount won by a single winner. 

KodyKlein
Asteroide

Thanks!

GGGDias
Asteroide

T1 is another case of unclear requirements.  Nobody ever one 6/6 of an 'ACCUMULATED' jackpot.  If you take out the 'accumulated jackpot' requirement, then you have a bunch.

Saqueador
WC_407.jpg

 

GGGDias
Asteroide

Anyone please DM me if there's a more elegant way than this in Alteryx (maybe a function exists) to convert decimal points to thousand separators and vice-versa

ToNumber(
replace(
replace(
replace([Prize won by each player (match 6/6)],'.',':')
,',','.')
,':', ',')
,2)