Results reference enables you to refer to the results of actions and formulas applied to Columns, Series, and other sub-components within the same Klip (this includes multicomponent Klips).
Results references are most commonly used with actions to leverage displayed data or results of the actions in other calculations. To use results reference, type & into the formula bar and select from the list. Watch the video below for more information.
Note: While results references refer to displayed data, formula references refer to formula's applied to other sub-components to enable easier Klip building and decrease the need for duplicate formulas. Learn more about formula references.
Calculating percentage change using results reference
You can use results references to simplify calculations like percentage of change.
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.
- Edit the Klip.
- Add a column to the table by increasing the Table Columns and set the Format as option to Percentage.
- 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.
- Edit the Klip.
- Add a column to the table and assign the Calls data to the fourth column in the table.
- 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.