Explains what the feature is or what its benefits are to the user or customer.
Your data may contain a column with a numeric data type that you have defined as an ATTRIBUTE rather than a MEASURE (such as age). You can allow aggregations on the values by changing the value of the Additive setting.
- A numeric data type (FLOAT, DOUBLE or INTEGER) or a date data type (DATE, DATETIME, TIMESTAMP, or TIME).
- The type ATTRIBUTE in the modeling file.
If you want aggregates to be added to the options for these columns, you need to change the Additive setting to YES. After you make this change, these options will be offered:
- TOTAL OF
- AVG OF
- STD DEVIATION OF
- VARIANCE OF
- TOTAL COUNT OF
- UNIQUE COUNT OF
- MIN OF
- MAX OF
To change the Additive setting:
- Find the column whose additive setting you want to change and select its Additive value.
- Change the value to one of these:
- Save your changes.