The explorer enables you to calculate new
data items from your existing data items by using an expression.
Note: All calculations are performed
on unaggregated data. The calculation expression is evaluated for
each row in the data source before aggregations are performed.
To perform calculations
on aggregated data, see Creating Aggregated Measures.
In addition to performing mathematical calculations on
numeric values, you can use
calculated data items to create
character values and date and time values. For example, if your data contains separate categories
for month, day, and year, then you can calculate a date value from each category.