Expressions: Overview

The FastStats Expression tool provides multiple functions that allow you to manipulate your data for analysis and/or output purposes.

You can use expressions in four places in FastStats:

FastStats supports the following in expressions:

 

FastStats also offers the ability to create Aggregated Expressions 'on the fly' and Derived Cube Expressions.

 

Added in Q1 2025 - Ability to copy one expression into another

We've introduced the ability for you to drag one expression into another using its drag handle. This copies all of the expression text to the insertion position of the new expression, and will also include any embedded queries, aggregations and cube lookups. Validation occurs to ensure you aren’t adding too many queries/cubes for the expression.

This development supports the creation of complex expressions and allows you to test part of an expression before then adding it into another you are already working on.

 

Added in Q3 2025 - Simplified process for adding an expression into a new selection

Adding an expression into a new selection is simplified so that you now just right drag the expression onto your FastStats workspace and select "Add expression to new selection" from the context menu.

When creating a selection using a date expression for analysis prior to the year 2000, remember to right click and define the required start and end years - see below.