Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #8: Aggregate Consumer Purchases

Anood
7 - Meteor

My solution 

gizemgurel
5 - Atom

Hi all, 

 

 

Spoiler
Snag_4a3010.png

Not too familiar with Cross- tab, so see Summarize-only solution:

1. Formula to limit dates

2. Summarize to Concatenate Description

3. Formula to enable filters on containing burger etc. 

4. Append Fields + % calculation

 

Response is attached.

 

deepaprash
8 - Asteroid

That was interesting. 

mark007
8 - Asteroid

Enjoyed that one!

Bernhardt03
7 - Meteor

Instead of creating another lookup table and using a cross tab, I concatenated the types. My solution is attached.

liamholland
8 - Asteroid
Spoiler
Solution Picture.png
Sudha8990AI
8 - Asteroid

Learned when and where to pivot the data.

 

Thanks,

Sudhakar S

Zangoly
8 - Asteroid

Solution to Challenge 8 - I have done it in a very inefficient way compare to the solution but i believe it still works.One thing, however, is the final values are slightly different and i am not sure know why (They are greater then the solution's but if anything they should be smaller).

Solution:

Spoiler
Zangoly_0-1587028827249.png
AnthonyPo
5 - Atom

Slightly different (and, may be, less fancy) from the original solution, but it still does the trick.

seinchyiwoo
Alteryx Alumni (Retired)

My solution: 

 

Spoiler
seinchyiwoo_0-1587113833169.png