Calculation

Show Me

To calculate a feature from other features, any SQL expression can be evaluated. The calculation can be as simple as adding or dividing two features, or it can be more complex as the problem demands.

For example, you might want to define the Sales percentage within a week (SALES_WK_PCT) by the following expression:

Total sales * 100.0 / Total week sales

Another example of using an expression is to calculate a day of the week (DAY_OF_WEEK) based on the following expression:

DAYOFWEEK(Date)

Feedback