# What is a Transformation

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 ![](/files/5GaGGZsIBZ17n2GDyK5b) .

![](/files/eVuB2uf2mpyxVCGiB3rh)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.verbdata.com/data-transformations/what-is-a-transformation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.