Calculated PowerMetrics: Examples

These examples show how, with calculated PowerMetrics, you can use simple equations and filtering to create a PowerMetric that lets you get the accurate and relevant data you need.

This article includes the following examples of using calculated PowerMetrics:

Calculating a rate using pre-built PowerMetrics

We have a lot of pre-built PowerMetrics in Klipfolio and are adding more all the time. But, if there’s something you need that we don’t have yet, you can combine existing pre-built PowerMetrics to display your data.

In this example, we show you how to create a PowerMetric for Google Analytics Bounce Rate by combining Bounces and Sessions (two of our pre-built Google Analytics PowerMetrics).

As a first step, you need to create the pre-built Google Analytics Bounces PowerMetric and Sessions PowerMetric to use in your calculation. Learn more about creating PowerMetrics here.

To create a Google Analytics Bounce Rate PowerMetric:

  1. In the left navigation sidebar, click the + beside PowerMetrics.
  2. Click Calculate a new PowerMetric.
  3. Enter the formula for calculating bounce rate using the Bounces and Sessions PowerMetrics you created earlier.

  1. Click Next.
  2. Set the Format to Percentage.
  3. Name your calculated PowerMetric and click Save.

Calculating a percentage of total

A percentage of total calculation is useful when you want to show your data as a ratio. Using simple math and filtering, you can create a PowerMetric that enables you to display the data you need.

In this example, we look at how to create a PowerMetric that displays the percentage of online chats that receive an offline message instead of chatting with a representative. As a first step, you need to create a PowerMetric that includes a count of all of your chats. This is the PowerMetric you will reference when building your calculated PowerMetric. Learn more about creating PowerMetrics here.

To create a percentage of total PowerMetric for offline chats:

  1. In the left navigation sidebar, click the + beside PowerMetrics.
  2. Click Calculate a new PowerMetric.
  3. Enter the formula for calculating your percentage of total.

Note: In this example, you are using the same referenced PowerMetric for both parts of the equation and filtering one to include a specific segment of the data (only offline messages).

  1. Apply a filter that selects only the Offline Messages to the first referenced PowerMetric in your formula.

  1. Click Next.
  2. Set the Format to Percentage.
  3. Name your calculated PowerMetric and click Save.

Displaying positive values as negative values

Sometimes your data includes values that are positive values but have a negative context. In these cases, you may want to display these as negative values to better understand your data. Using simple math and filtering, you can change the way your data is displayed.

In this example, we describe how to create a PowerMetric that displays lost deals as negative values. Make sure your referenced PowerMetric includes both your won and lost deals data. The following PowerMetric shows both won and lost deals as positive values.

To display your lost deals as negative values:

  1. In the left navigation sidebar, click the + beside PowerMetrics.
  2. Click Calculate a new PowerMetric.
  3. Enter the formula for displaying lost deals as negative values.

Note: In this example, you are using the same referenced PowerMetric for both parts of the equation and will be filtering each one to include different data (won deals and lost deals). Multiplying the data by -1 will turn the lost deals data into negative values.

  1. Filter the first PowerMetric to include only Won deals and the second to include only Lost deals.

  1. Click Next.
  2. Name your calculated PowerMetric and click Save.

When you display your PowerMetric as a stacked bar chart, you can quickly compare and see your lost deals as negative values.

Learn more

Have more questions? Submit a request