Relationship

To combine data from multiple tables, a relationship requires a primary key in one of the datasets

Click Relationship in the Options tab to see all relationships created in the dashboard. To edit the relationship, click Edit in the sidebar menu to open the edit menu and follow these steps:

1. In the Options tab, click Relationship. Tables from your created charts will be automatically input into the relationship space.

2. Hold the field from one table and drag them to the other field from another table to build a connection line between them. You can build multiple lines from different tables and many connections from one source field.

3. After creating the relationship, you can collapse the table to show only connected fields.

4. Click on the connection line and click Remove Relationship to remove the relationship between two connected fields.

5. After creating relationships, click Save to save the progress.