Create a Calculated Dimension

In the General section:

• Name your calculated dimension.
• Select the type of calculated dimension you want to create:
  • Text — Appears as a string (numbers appear as numbers not text).
  • Number — Appears as a number.
  • Date — Appears in a date format (according to your settings).
  • Link — An active link.
  • Image — Appears as a thumbnail.
  • Video — Appears as a link to the video in a new browser tab.
  

  Note The ‘type’ affects the formats available in the dashboard widget settings, in most cases, you should set the type to Text.
• Add a description of the calculated dimension.

In the Advanced section, you can define advanced settings such as:

• Related Measurement — Select a measurement that is linked to your calculated dimension’s formula, to enable you to populate lists with calculated dimension values - for example, you have a calculated dimension that returns Email Name with the related measurement of Clicks. When this calculated dimension is used in a widget, the returned Email Name values will only be of emails that had at least 1 click within the date range that the page is filtered on. If no related measurement is used, all Email Names are returned, including those without clicks.
• Invisible Dimension — Select this checkbox to hide any widget that contains this calculated dimension from users who do not have the ‘Create and Edit’ permission.

In the Expression section, insert the expression you want to base the calculated dimension on. For example, if your customer's Email Names consist of multiple concatenated values, you can create calculated dimensions to extract these values and create fields out of them using the formula: EXTRACT([Email_Name],'_',1).

On the right-side menu, use the list of available dimensions and functions to create your expression. Click on a function to add it to your expression or start typing for auto-complete. You can use any of the available functions together with any of your available fields.