Lookup fields let you create a chart that joins data from multiple collections in the same database. You can create a lookup field from any field in your chart's data source that isn't an embedded object and contains matching data with a field in another collection. The remote collection must be:
Connected to Charts.
Part of the same database as the local collection.
You can also use the local collection as a lookup field source.
To add a lookup field:
Hover on an existing field and click on the ellipsis (...).
Select Lookup field.
A modal window appears:
Select the desired collection and field.
The remote field must contain at least one document with data that matches the local field, or the lookup field is empty.
Select whether to return all matching documents from the foreign collection or only the first matching document.
Specify a name for the field.
Click Save.
The new field appears with a binoculars icon. This icon indicates lookup fields.
To learn more, see Add a Lookup Field.