Data Shaping & Processing

• All basic statistical operations (count, sum, minimum, maximum, average, variance, etc.) The fullest list of aggregates:

Sum
Count
Minimum
Maximum
Average
Multiplication
 Variance
Standard deviation
Shifted Variance
Shifted Standard deviation
Number of unique
First value
List of unique
Last value
Median
Weighted arithmetic mean
Expression (script)
Expression (script) based on the source data

• Automatic separation of date and time

• Calculated values in created measures or columns (based on FastScript)

• Calculated filters for numeric data by using output formatting (based on FastScript)

• Powerful script engine FastScript for complex data processing. Common script space for all calculated measures makes it possible to share code between them.