What is a Transformation

There are 3 types of transformations available in Verb

Transformations allow you to manipulate and create new data that can be used in your dashboards and reports. Transformations are automatically run on your data as it's ingested or rendered in a collection, ensuring performance and consistency. The Verb transformation builder uses a configuration-based interface so that there is no SQL or code to write.

Calculated Columns

A Calculated Column uses data from the host table and any other table in the model to create a new column that is appended to every row of the host table. As new data is ingested from data sources Calculated Columns are automatically processed and the new data is available in Collections.

Calculated Columns are designated with a “+”.

Aggregated Measures

An Aggregated Measure is built similarly as a Calculated Column but the calculation of the data occurs after the returned data for a specific tile in a collection is segmented and filtered. Aggregated Measures can only use the host table and its columns as inputs.

Aggregated Measures are designated with a “fx”.

This is most often used for calculating marketing related measures like “cost per click” as all filters and segmentations need to be applied in order to determine the relevant aggregated cost and the number of clicks.

Data Views

Data Views use data from any ingested data source Table or other Data View in the model to create a new table of data. As new data is ingested from data sources Data Views are automatically processed and the new data is available in Collections.

Data Views are shown in a separate section in the left panel of the model section and they are always designated with a .