Adding derived columns

Derived columns are used for including more complicated calculations, often consisting of complex queries. In this article, you'll learn how to summarize data by following a relationship to another table.

2 min read - Start now

If the node type displayed in your table has any relationships, you can add Derived Properties, to follow the relationships and aggregate values from the connected nodes.

To add Derived Properties, Click the Add button next to “Derived Properties” under the Analyze section on the left hand side of the page.

A pop-up will appear that will allow you to build a complex query to find all the matching nodes.

Click the blue “+” button and select “Select Connected Nodes” from the dropdown.

A “Find Connected Nodes” drop down will appear. Next to “Type” there is a dropdown of the possible relationships you can follow. An arrow indicates the path of the relationship. In this example, from Artists to Albums.

You can then add an Aggregation. Click the blue “+” button again and select “Aggregate” from the dropdown.

Select the Column that you’d like to aggregate from the dropdown menu. Then select the desired function. Select Add.

Now, a new column will be added to your table - the derived column.