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!

Practice Exercise

Learning Path 1: Exercise 2: General

Rinshad
6 - Meteoroid
 
sarahjohnson
8 - Asteroid
 
Odwyer
5 - Atom
 
jeng
8 - Asteroid
 
madeleineK
6 - Meteoroid
 
MFish
8 - Asteroid
 
PhilippK
Alteryx Alumni (Retired)
 
jstewart
7 - Meteor

Some assumptions need to be made for this exercise. One, customer entries are not unique at the annual transaction level so I average the two. Also, Not all customers contain user details so i thought including all data even where user details are not available would be valuable with a additional union after the join on sale and customer join. 

 

P.S. pipes are (Shift+\), not (ctrl+\). 

JeffS
Alteryx Alumni (Retired)
 
RogerL
6 - Meteoroid