Editing data feeds: Writing formulas using results references (NEW)

 

Our recent redesign simplifies the data transfer experience by combining raw and modelled data sources into a single object - data feeds. We’re gradually releasing this new feature to our customers.
If you see Data Feeds in the left navigation sidebar, you’ll in the right place. If not, go here.

You can use results references when editing data feeds. Results references enable you to refer to columns within the data feed after date properties and formulas are applied to them. To use a results reference, type & into the formula bar and select from the list that displays.

This article includes the following examples of using results references:

Adding column data together to create a total column

In the data feed editor, you can use simple math (addition) and results references in your formula to add columns of data together to create a single, totalled column.

The data feed to be edited (as shown below) includes separate columns for sales in January, February, and March:

The following example uses simple math (addition) and results references to add three columns of data together to create a single totalled column.

To add data from separate columns together into one totalled column:

  1. Click Data Feeds in the left navigation bar.
  2. From your list of data feeds, select the one you want to edit.
  3. Click the Edit button in the top navigation bar.
  4. Click the + column. (It displays after the last column in your data feed.)

This adds a new, empty column and opens the formula bar.

  1. Click in the new column’s header and enter a new name “Q1 Sales”.
  2. With the new column selected, enter the formula (as shown below) into the formula bar, and click Enter.

Your new column is populated with the consolidated data, according to the formula you entered.

  1. Click Save data feed.

Consolidating related data

When editing a data feed, you can use the CONCAT function and a results reference in your formula to consolidate related data from separate columns into a single column.

The data feed to be edited (as shown below) includes separate columns for sales rep names and sales rep IDs:

The following example uses the CONCAT function and a results reference to combine sales rep names (from one column) and sales rep ID numbers (from a different column) into a single, consolidated column that includes the sales rep names alongside their ID numbers.

To consolidate data using CONCAT and a results reference:

  1. Click Data Feeds in the left navigation bar.
  2. From your list of data feeds, select the one you want to edit.
  3. Click the Edit button in the top navigation bar.
  4. Click the + column. (It displays after the last column in your data feed.)

This adds a new, empty column and opens the formula bar.

  1. Click in the new column’s header and enter a new name “Name and ID Number”.
  2. With the new column selected, enter the formula (as shown below) into the formula bar, and click Enter.

Your new column is populated with the consolidated data, according to the formula you entered.

  1. Click Save data feed.

Related articles

Have more questions? Submit a request