Congratulations on completing Exercise 1!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
.
Practice 1
Practice Exercised 1
Solution for Problem.
Submitting Exercise 1
See attached!
Solution
Practice Exercise 1
First attempt
Result of first execise
Exercice Solution
hi
i tried using tools to find the solution in my way.
solution
Here it is...
Here you go!
done
I attached my solution
I used the select tool to de select weekly sales and store volume. I then applied the the Sort tool to in descending order, (TransInYear). Then I used the filter tool to filter regions to equal to south. I then used the sample tool to show the 5 first customers with the highest average transactions
Here is solution for Exercise 1.
Refer to attached solution
First you use SELECT tool to remove "weekly sales and store volumes" column and also rename the "TransInYear" column to "Annual Transaction". Then, use a FILTER tool to get the Average of annual transactions for south region only using formula-{ [Region] = "South" AND Average([Annual Transaction])}. Sort the data from TRUE output to get descending value of annual transaction (average now) and then use SAMPLE tool to get First 5 rows.
This is my first solution
Exercise 1 Solution
My solution~
Happy to learn Alteryx!
Here u go
