About linked views

Linked views are created automatically when you link two data sets.

For each data set that has links to other data sets, Studio creates a combined linked view that contains:
  • All of the attribute for that data set
  • The attributes from the other data sets, aggregated based on the link key

Linked views are read-only, and do not allow for any configuration or customization. You also cannot copy a linked view.

So for the following links among the Products, Customers, and Sales data sets:


Diagram showing three linked data sets

Studio creates the following linked views:


Diagram showing the combined views created from the three linked data sets
Linked View Description
Products - linked Contains the Products records with Sales attributes added in.

The Sales attributes are aggregated by product SKU.

For example:
  • The sales amount (from Sales) for each product is the total for all of the sales for the product.
  • The customer name (also from Sales) for each product is a list of customers that purchased the product.
Customers - linked Contains the Customers records with Sales attributes added in.

The Sales attributes are aggregated by the Customer First Name and Last Name.

For example:
  • The sales amount (from Sales) for each customer is total for all sales to that customer.
  • The product SKU (from Sales) for each customer is a list of SKUs for products purchased by that customer.
Sales - linked Contains the Sales records with the Products and Customers attributes added in.

The Products information is aggregated by product SKU, and the Customers information is aggregated by the Customer First Name and Customer Last Name.

In this case, because each sales record has a single product and customer, there is still only a single value for each product and customer field.