---
schema_version: "1"
id: baef778088ec77ad3ce4c39b7078f741b15a3466c5303f5ed20057e79f4f874b
title: Create a Calculated Dimension from a Widget
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_dimensions_calc_widget.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_dimensions_calc_widget.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2a7dc41f7277334649ab42d662b62dfc7c784c7406574097ea86d14d1f738dc6
description: Create calculated dimensions on top of existing data and refer to them across your workspace.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Calculated Dimension from a Widget

Create calculated dimensions on top of existing data and refer to them across your workspace.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d94982e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d94982e38 ">Create and manage calculated dimensions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d94982e38 ">Power User or Admin</td>

          </tr>
        </tbody>
      </table>

1. On the **Visualize** tab, click a dashboard page.
2. Click the pencil icon to enter edit mode.
3. To add a widget, click the plus icon.
4. Select the widget type, and then click the plus icon to add a field.
5. Click the **Add Calculated Field** icon ![Plus sign followed by a Greek capital sigma](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/add_calc_field_icon.png), and then click **Calculated Dimension**.
6. In the **General** section, name the dimension, add a description, and select the type.
    
    The type affects the format in the widget settings. In most cases, select **Text**.
7. In the **Advanced** section, you can link a measurement to the calculated dimension’s formula to populate lists with the dimension’s values. For example, you have a calculated dimension that returns an email name with the related measurement of clicks. When the calculated dimension is used in a widget, the returned email name values are only emails that had at least one 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.
8. To hide widgets that contain the calculated dimension from users who don’t have Admin or Power User permissions, select **Invisible Dimension**.
9. In the **Expression** section, enter the expression that you want to base the calculated dimension on. For example, if your customers’ email names consist of multiple concatenated values, you can create a calculated dimension to extract the values and create fields using the formula `EXTRACT([Email_Name],'_',1)`.
    1. Create an expression using the list of available dimensions and functions. To add a function to your expression, click it or start typing for auto-complete.
    2. Apply any of the options that appear at the bottom.
        
        <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Full Screen</strong></td><td class="slds-cell-wrap">View the expression section in full-screen mode.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Auto Format</strong></td><td class="slds-cell-wrap">Format your code into the standard correct structure.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Comment</strong></td><td class="slds-cell-wrap">Enter a comment within your expression.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Uncomment</strong></td><td class="slds-cell-wrap">Remove your comment from the expression.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Code Validation</strong></td><td class="slds-cell-wrap">Validate that your expression is accurate.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Test</strong></td><td class="slds-cell-wrap">Test your expression.</td></tr></tbody></table>
10. Click **Save**

#### See Also

- [Create a Calculated Dimension from the Calculated Dimension Tab](https://help.salesforce.com/s/articleView?id=mktg.dato_dimensions_calculated_create.htm&release=264.0.0&type=5 "Create calculated dimensions on top of existing data and refer to them across your workspace.")