Calculated Dimensions

Available in: Intelligence Reports Advanced

You can create a calculated dimension from the widgets in the dashboard pages, and there are many functions you can use. Maintenance is easy and flexible. And any change you make in the calculated dimension is automatically applied wherever it’s used across your workspace.

You can use calculated dimensions to:

• Consolidate dimensions – If you have dimensions that display long names, such as email addresses, use the IF function to extract the name of the email without manipulating the actual data that you bring into Intelligence Reports.

  For example: IF([Email_Domain] contains 'hotmail.autonto.com', ‘Hotmail’])

• Remove unwanted characters – If a dimension value includes characters that you want to extract, use the Extract() function. Allowing you to extract the substring, at the given position, after splitting by the given delimiter.

  For example, EXTRACT([Email_Name],'-',0) extracts the email name.

• Create a Calculated Dimension
  Create calculated dimensions on top of existing data so you can refer to them from different tabs. You can also create calculated dimensions from a widget on a dashboard page. Calculated dimensions created from widgets appear in the calculated dimension part of the Setup tab.
• Calculated Dimension Functions
  You can use Functions when creating calculated dimensions.
• Calculated Dimensions Use Cases
  Use these examples when creating calculated dimensions in Intelligence Reports Advanced to easily create fields. Each example contains an explanation with a code sample.
• Find and Replace Calculated Dimensions
  You can use the find and replace function to search for a specific dimension, edit and replace the edited dimension across your entire business unit. You can do this without searching for the location of the calculated dimension, which is especially useful when creating a calculated dimension that is meant to replace an existing dimension.