In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Practice Exercise

Learning Path 1: Exercise 2: General

Rinshad
6 - Meteoroid
‎10-21-2019 04:33 AM
 
Practice Exercise 2.yxmd
Reply
0 Likes
sarahjohnson
8 - Asteroid
‎10-21-2019 08:24 AM
 
Practice Exercise 2.yxmd
Reply
0 Likes
Odwyer
5 - Atom
‎10-22-2019 03:46 AM
 
Practice Exercise 2.yxmd
Reply
0 Likes
jeng
8 - Asteroid
‎10-22-2019 05:54 AM
 
Practice Exercise 2.yxmd
Reply
0 Likes
madeleineK
6 - Meteoroid
‎10-22-2019 01:53 PM
 
Practice Exercise 2_MK.yxmd
Reply
0 Likes
MFish
8 - Asteroid
‎10-22-2019 07:00 PM
 
Prac Exercise 2 Mfish.yxdb
Reply
0 Likes
PhilippK
Alteryx Alumni (Retired)
‎10-23-2019 04:21 AM
 
Practice Exercise 2.yxzp
Reply
0 Likes
jstewart
7 - Meteor
‎10-23-2019 08:44 AM

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+\). 

Practice Exercise 2.yxmd
Reply
JeffS
Alteryx Alumni (Retired)
‎10-23-2019 09:26 AM
 
Practice Exercise 2.yxzp
Reply
0 Likes
RogerL
6 - Meteoroid
‎10-24-2019 05:03 AM
 
Practice Exercise 2 solution.yxmd
Reply
0 Likes