LogoLogo
Home
  • Verb Documentation
  • Release Notes
  • Environment Settings
    • Authentication
      • Authentication Endpoint
  • Data Sources
    • Ingestion Methods
    • Table Sync Intervals
    • Data Source Integrations
      • Network Permissions
      • Microsoft SQL Server
      • PostgreSQL
      • MongoDB
      • Snowflake
      • Elasticsearch
      • DynamoDB
      • Google BigQuery
      • Firebase Cloud Firestore
      • Supabase
      • Cloud Files
      • Flat Files
    • Data Synchronization
      • Synchronization Methods
        • Full Synchronization
        • Incremental Synchronization
        • Change Tracking
        • Change Data Capture
      • Synchronization Intervals
      • Synchronization Status
        • Pausing and Resuming
      • Synchronization History
      • Schema Changes
      • Row Filtering
      • Schemaless & NoSQL
      • Managing Connections
      • Troubleshooting
  • Models
    • What is a Model
      • Elements of a Model
      • Model Management
    • Building a Model
      • Add/Remove Data
      • Relationships
      • Row-Level Security
      • Transformations
    • Advanced Model Information
      • Database Keys
      • Unstructured Data
      • Publishing Updates
      • Troubleshooting
      • Automatic Modeling
  • Data Transformations
    • What is a Transformation
      • Elements of a Transformation
      • Transformation Management
    • Building Transformations
      • Creating Transformations
      • Configure Transformation Steps
      • Transformation Steps
        • Calculator
        • Manipulate Text
        • Map Values
        • Remove Duplicates
        • Date Operation
        • Select Columns
        • Change Type
        • Group Data
        • Filter Data
        • Join Data
        • Append Rows
        • Pivot Data
        • Rank Data
        • Window Data
      • Complete and Publish
  • Collections
    • What is a Collection
      • Elements of a Collection
    • Building Collections
    • API Collections
      • Building API Collections
        • Connect Data Sources
        • Data Model
        • Select Data
        • Authentication and Security
        • Data Access API Keys
        • Data Access API Documentation
      • API Collection Versions
    • Advanced Collection Options
      • Time Zones
      • Currency Symbols
  • Tiles
    • What is a Tile
      • Elements of a Tile
    • Tile Management
      • Tile Data
    • Tile Actions
    • Custom Date Formats
    • Currency Conversion
  • Design Themes
    • What is a Design Theme
    • General Theme Settings
    • Data Visualization Settings
  • Account Settings
    • Integrations
      • Slack
  • Legal
    • Terms of Use
    • Privacy Policy
    • Subscription Agreement Terms
    • Subscription Agreement
    • Data Processing Addendum
Powered by GitBook
On this page
  • Calculated Column (+)
  • Aggregated Measure
  • Data Views

Was this helpful?

  1. Models
  2. Building a Model

Transformations

PreviousRow-Level SecurityNextAdvanced Model Information

Last updated 3 years ago

Was this helpful?

Transformations allow you to manipulate and create data in your model. They can be created as columns on existing tables using calculated columns or aggregated measures. Transformations can also be created as data views, which will act like Tables.

Transformations must be published to be available in Models and Collections.

Calculated Column (+)

A calculated column is a column added to every row in the host table. If data is not being ingested in a desired format or further manipulation is necessary, adding a calculated column in a variety of transformations enables filtering, sorting, and manipulation for ease of use.

Once a calculated column is created it can be found in the table list on the left panel.

To create a calculated column on a table, select the “Add Calculated Column” option from the table menu.

Aggregated Measure

A calculation that occurs after the returned data for a specific tile in a collection is segmented and filtered. 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.

Once an aggregated measure is created it can be found in the table list on the left panel.

To create an aggregated measure to a table, select the “Add Aggregated Measure” option from the table menu.

Data Views

Data Views are Transformations that are stored as Tables in the model.

Once a Data View is created it can be found in the Data Views section on the left panel.

To create a Data View, select the “Add Data View ” button from the left panel.