Example of formulas in the Data Manager

This page contains some examples on how formulas can be used to fill new attributes with values.

Apart from the functions listed in the page Formulas and Functions in the Factory, you can apply other formulas, depending on your needs.

The following examples use the Bike sales dataset.

Example 1

In this example, we want to define the values of a new attribute called ratio.

We have filled its values by typing the ratio between Profit and Cost multiplied by 100. The attribute type has been automatically changed to continuous.

Example 2

In this example, the attribute Location is the result of the concatenation of the strings of Country and State, separated by the constant string “-”.

Example 3

Through formulas, you can also re-define existing attributes' values, for example we want the Sub_Category attribute not to have the constant string “Racks”.