How do I use results reference?

Results reference enables you to refer to Columns, Series, and other sub-components after actions, date properties and formulas are applied to them. You can reference sub-components within the same Klip (this includes multicomponent Klips).

Results references are most commonly used with actions and date properties to leverage displayed data or results of the actions and date properties in other calculations. To use results reference, type & into the formula bar and select from the list. 

Watch the video below for more information.

In this article we discuss two common use cases with results reference:

  1. Calculating the percentage of change between two periods of time
  2. Aligning data from two data sources in one Klip

Note: While results references refer to displayed data, formula references refer to formulas before actions or date properties are applied. Learn more about formula references.

Calculating percentage change using results reference

Follow the steps below to learn how to use results references to simplify calculations like the percentage of change between two periods of time. 

The Klip below shows the total sessions coming in from different mediums by month.

 

In this example, a column is added to the Klip to show the percentage of change between the sessions in the previous month and the current month.

  1. From your dashboard, use the three-dot menu on your Klip and click Edit to go the Klip Editor.
  2. Add a column to the table by increasing the Table Columns and set the Format as option to Percentage. 
  3. Select the Data tab and perform a percentage of change calculation using results references like the image below. 

Aligning data from two data sources

You can build Klips using two data sources and align the data using the LOOKUP function. Using results reference in the LOOKUP formula enables you to reference columns after actions have been applied to them and maintain the results in further calculations.

The Klip below shows data for campaigns, clicks, and sessions from one data source. 

In this example, a column with calls data is added from a second data source using the LOOKUP function and results reference to ensure the actions applied to the data from the first data source are also applied to the calls data from the second data source.

  1. From your dashboard, use the three-dot menu on your Klip and click Edit to go the Klip Editor.
  2. Add a column to the table and assign the Calls data to the fourth column in the table. 
  3. In the Calls column, use the LOOKUP function to ensure that the calls from the second data source are aligned with the rest of the data as shown in the image below. 

Related links: