Calculated metrics: Examples

These examples show how, with calculated metrics, you can use simple equations and filtering to create a metric that gets you the accurate and relevant data you need.

This article includes the following examples of using calculated metrics:

Calculating a rate using pre-built (instant) metrics

We have a lot of instant metrics 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 instant metrics to display your data.

Note: As mentioned above, we are continually adding new instant metrics. After the following example was published, we added "Website Bounce Rate" to our growing list of Google Analytics instant metrics. We decided not to unpublish this example, as it's also applicable to other services where we don't yet have the instant metric you're looking for.

In this example, we show you how to create a metric for Google Analytics Bounce Rate by combining Website Bounces and Sessions (two of our instant Google Analytics metrics).

As a first step, you need to create the instant Google Analytics Website Bounces metric and Sessions metric to use in your calculation. Learn more about creating metrics here.

To create a Google Analytics Bounce Rate metric:

  1. In the left navigation sidebar, click Metrics to open the Metric List page.
  2. Click + Add metrics.
  3. Click Calculate a new metric.
  4. Enter the formula for calculating bounce rate using the Website Bounces and Sessions metrics you created earlier.

  1. Click Next.
  2. Set the Format to Percentage.
  3. Name your calculated metric 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 metric that enables you to display the data you need.

In this example, we look at how to create a metric 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 metric that includes a count of all of your chats. This is the metric you will reference when building your calculated metric. Learn more about creating metrics here.

To create a percentage of total metric for offline chats:

  1. In the left navigation sidebar, click Metrics to open the Metric List page.
  2. Click + Add metrics.
  3. Click Calculate a new metric.
  4. Enter the formula for calculating your percentage of total.

Note: In this example, you are using the same referenced metric 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 metric in your formula.

  1. Click Next.
  2. Set the Format to Percentage.
  3. Name your calculated metric 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 metric that displays lost deals as negative values. Make sure your referenced metric includes both your won and lost deals data. The following metric shows both won and lost deals as positive values.

To display your lost deals as negative values:

  1. In the left navigation sidebar, click Metrics to open the Metric List page.
  2. Click + Add metrics.
  3. Click Calculate a new metric.
  4. Enter the formula for displaying lost deals as negative values.

Note: In this example, you are using the same referenced metric 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 metric to include only Won deals and the second to include only Lost deals.

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

When you display your metric 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