Analytics SAQL Developer Guide

Overview
Quick Start
Write Your First Query
Create a Derived Measure
Create a Derived Dimension
Examples
SAQL Reference
Query Performance
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Create a Derived Dimension

Perform string manipulations on existing dimensions to create a new, or derived, dimension.
CRM Analytics creates derived dimensions at run time.

You can also create a derived dimension in a dataflow rather than at runtime.

Note

Example - Create a Field with City and State

Suppose that you have an Opportunities dataset with a City and a State field. You want to create a single field containing both city and state. Use SAQL to create a derived dimension.

The resulting table contains city and state in the same field.

Derived dimension shows time to win