Using LiveDataset

Edit data and create datasets you can share.

LiveDataset

Navigate to Related Datasets

Often datasets will have a logical relationship with other datasets.
e.g. Projects and people assigned to work on projects.

For most related datasets there is one column that is shared by both datasets. This shared column can be used to “lookup” data from the related dataset.

Here the “Project” column is shared with a Projects dataset and the “Senior PM” value is brought into this dataset by looking up the “Project” in the Projects dataset.

Navigate helps you quickly find relevant information in related datasets.

 

Press to display the navigate bar.

The navigate bar has buttons that

  • show which datasets are related to this dataset
  • can be pressed to open related datasets

 

Select an entry in the data grid to display blue related entry buttons that

  • show how many related entries the selected entry has
  • can be pressed to open the dataset and only show the related entries

Here the selected entry has 18 related entries in the Projects dataset and 1 in the Resources dataset.