Consolidated feed overview

Consolidated feeds are an advanced feature of Data Everywhere that allow you to take multiple feeds of similar data, and collate and output a single feed containing all of the data from these child feeds.

Consolidated Feed Example

It is best explained with an example. Pretend we are attempting to track hours on a billable project. Jill and Joe are both working on the project, and they can each keep their tracked time in independent feeds like the following.

Jill's timesheet feed:
Employee Name Date Hours Notes
Jill 1/1/2015 1.5 Initial planning and estimation meeting
Jill 1/2/2015 3.0 Research into planned process
Joe's timesheet feed:
Employee Name Date Hours Notes
Joe 1/1/2015 1.5 Initial planning and estimation meeting
Joe 1/2/2015 2.0 Setup of development environment

Given these two timesheets, consolidated feeds allow you to produce a single Data Everywhere feed that looks like the following, and can be inserted into any of your spreadsheets and shared with anyone.

Consolidated timesheet feed:
Employee Name Date Hours Notes
Jill 1/1/2015 1.5 Initial planning and estimation meeting
Jill 1/2/2015 3.0 Research into planned process
Joe 1/1/2015 1.5 Initial planning and estimation meeting
Joe 1/2/2015 2.0 Setup of development environment

Creating and Using a Consolidated Feed

  1. To get started, head over to your Data Everywhere feeds page.
  2. Click the "Create a Consolidated Feed" button at the top of the page.
  3. Here, you can give the new feed a name and optional description. It is helpful to choose a name that indicates the purpose of the feed, such as "All Timesheets", "Consolidated Timesheets", etc.
  4. Click "Create Consolidated Feed". You will now be brought to the consolidated feed configuration screen.
  5. Here, you can add feeds as children to the consolidated feed. In our example above, we would choose and add both "Jill's Timesheet" and "Joe's Timesheet" to our consolidated feed. Note that you must have at least viewer permission on a feed to be able to add it as a child.
  6. Your consolidated feed is now created! You can use your preferred Data Everywhere add-in to insert this feed into either an Excel spreadsheet or Google Sheets document.
  7. When any child feed is updated, the consolidated feed will also be updated with the latest data.

Frequently Asked Questions

What happens if child feeds have different columns?

Data Everywhere will match columns based on the column name, not based on the order of the columns. As long as your columns are consistently named across child feeds, consolidated feeds should be able to assemble your data correctly. Any columns that are not present in some of the child feeds will simply have blank values for those rows.

For example, Jill and Joe's timesheets could have their columns in different order and everything would still work in the example above.

Can my columns be in any order?

Yes, they can. Column headers will be listed in the same order as they are in the first feed, with any columns only present in other feeds added to the right of the table.

For example, if Joe's timesheet (but not Jill's timesheet) had an "Internal Comments" column before the "Notes" column, it would show up as the last column in the consolidated feed, after "Notes".

How do permissions on consolidated feeds work?

If you share a consolidated feed with a user, that user will have access to the entire feed, even if she doesn't have access to one or more underlying child feeds.

The data in a consolidated feed is always read-only. This means that no one is an editor, including the creator.

Only the creator of the consolidated feed can edit the list of underlying child feeds.

Still need help? Contact Us Contact Us