Initial State
Start 1.yxdb
Start 1.yxdb
Practice Exercise 1
Find the five customers with the highest number of transactions in the Southern region and remove the "Weekly Sales" and "Store Volume" columns.
An Input Data tool contains 100 records, each representing a unique customer's transaction information. The Customer ID (a unique identifier for each customer) and Customer Segment provide basic information about the customer. The transactions column represents the average number of transactions that customer has made over the past year.
In this exercise, drop the columns "Weekly Sales" and "Store Volume". Then find the 5 customers with the highest average transactions in the "South" region. Your results window should match the Final State Input Data tool.
Final State
Final State - Exercise 1.yxdb
Final State - Exercise 1.yxdb
Region - Descending
TransInYear - Descending
[Region] = "South"
Simple
=
Region
True
fixed
2019-10-30 11:56:29
0
South
2019-10-30 11:56:29
2019-10-30 11:56:29
[Region] = "South"
First
5
First 5
Horizontal
Practice Exercise 1