Workbook Data Lineage (Beta)

Workbook lineage refers to the ancestry and relationships between data elements in a workbook. All workbooks contain a lineage display, allowing you to oversee and navigate these relationships. 

A few use cases for data lineage include:

  • Determining how changes to a data element will affect any child elements
  • Determining the location from where unexpected data is coming / being calculated
  • Cleaning up existing workbooks to remove unused or redundant elements or calculations
  • Diagnosing the source of data and/or permission errors

This article covers how to view and navigate any workbook’s lineage display.

This feature is currently in beta. Beta features are subject to quick, iterative changes. As a result, this document may not reflect the most current version.

Summary of Content

View Workbook Lineage
View Lineage by Workbook Page
Open Lineage for a Specific Element
Navigate to a Workbook Element from its Lineage
Related Resources

View Workbook Lineage

  1. Open the workbook.
  2. Click the lineage icon (Screen_Shot_2022-01-05_at_10.16.12_AM.png), located near the bottom of the workbook’s left sidebar.
    Screen_Shot_2022-01-05_at_10.11.38_AM.png
    This will open the workbook’s lineage display.
    Screen_Shot_2022-01-12_at_10.18.42_AM.png

Now what?

View Lineage by Workbook Page

  1. Open the workbook’s lineage display from the workbook’s left sidebar.
  2. Click the dropdown menu located in the top right corner of the page.
    By default, it is set to Show all elements.
  3. Select a workbook page from the menu.
    Screen_Shot_2022-01-12_at_10.19.10_AM.png
    The display will then show only elements of the selected page.
    Screen_Shot_2022-01-12_at_10.20.25_AM.png

Open Lineage for a Specific Element

  1. Hover your cursor over the element.
  2. Click the vertical ••• icon button in the element’s inline toolbar.
  3. In the menu, you will see one of two options: View full lineage or a View lineage submenu.
    The View lineage submenu is only shown for elements that source other elements (children).
    Select View full lineage or a child element.
    Screen_Shot_2022-01-12_at_12.06.02_PM.png

 

Navigate to a Workbook Element from its Lineage

  1. Open the workbook’s lineage display from the workbook’s left sidebar.
  2. Click to select an element’s indicator.
    When selected, an indicator is highlighted. It’s also displayed on the right side of the screen.
    Screen_Shot_2022-01-12_at_10.24.36_AM.png
  3. On the right side of the page click View element.
    Screen_Shot_2022-01-12_at_10.23.46_AM.png

Related Resources

Intro to Data Elements