Calculated Measurements

Available in: Intelligence Reports Advanced

Calculated measurements can be a simple mathematical expression that generates a calculation, or they can be a body of code with advanced conditioning and logic. You can use calculated measurements in dashboards, reports, or pivot tables.

Use Case

You want to calculate the key performance indicators (KPIs) in Intelligence Reports for Engagement, using a different formula. For example, in Intelligence Reports, the Email Open Rate is calculated by dividing the Unique Email Opens by the Email Deliveries. With calculated measurements, you can create another version of the Email Open Rate that uses the Email Sends as the denominator instead of the Email Deliveries. You can also create your own KPIs, in addition to the preconfigured measurements in Intelligence Reports using Calculated Measurements.

• Create a Calculated Measurement
  Create calculated measurements on top of existing data so you can refer to them in other tabs. You can also create calculated measurements from a widget on a dashboard page. Calculated measurements created from widgets appear in the calculated measurements section in the Setup tab.
• Calculated Measurement Functions
  Use functions when creating a calculated measurement in Intelligence Reports Advanced to make your functions more dynamic.
• Calculated Measurements Use Cases
  Use these examples when creating calculated measurements to easily create fields. Each example contains an explanation with a code sample.
• Find and Replace Calculated Measurements
  You can use the find and replace function to search for a specific measurement. Then, you can edit and replace the edited measurement across your entire business unit without finding every location where the calculated measurement is used. This feature is especially useful when creating a calculated measurement that is meant to replace an existing measurement across your business unit.