How many orders do customers living in DARWEN have? You can answer this by using an Aggregate to group the information from the different tables in a single one...more

How can you make a field friendlier by associating different names with its values? You can do this by using the "Decoder" engeneering tool. it enables you to recode the fields you want to in order to simplify analysis tasks...more

How can you get the number of orders by the year in which they are placed? You can do that by using an "Expression" to create a field calculated by using operations, functions or expressions...more

How can you get a field with customers' full names? And group customers by "adults" or "young people"? How can you get the cost in the order line? You can do that by using the "Expression" tool to create fields calculated using operations, functions and expressions...more

How can you group the value of orders placed by directors in ranges? You can do this by using the "Numeric ranges" engineering tool. It enables you to create a new field based on a numeric field and gropu the various values in significant numeric ranges...more

How can you divide customers by age into 10 equal groups? You can do that by using a "Quantile Range" to divide the sample into N grupos that are equal in terms of the number of registers in each one. These groups are created in ranges after having sorted the registers in ascending order so that the first range contanins the smallest registers and the last range the largest registers...more

How can you obtain in the Customers table a field with the following records: customers who placed orders in March 2003, customers who bought products in the "MA" family, customers over 55 years of age living in "London" and clients who are women directors? You can do that by using a Parametric which creates a field that contains values based on queries...more