This is driving me crazy because it's so simple in Drupal 7.
Basic page has a entity referenced field where you can type in Spotlights that should be shown at the bottom of the page.
Relationships (in order) is the field_spotlights (which exists on the Basic Page) and field_spotlight: Content using the previous relationship.
Contextual filter is the ID of the node, based on current id of page. Uses the field_spotlights relationship
Fields are the fields that exist in the spotlight, each with a relationship with field_spotlight: Content.
So the above should show only 3 results if the basic page is viewed and only has 3 spotlights in the entity referenced field.
However 4+ spotlights are showing, it's including the 3 that should show but then duplicates some or shows more.
I've tried using Aggregation too, by adding a Content ID to the fields, and setting the aggregation setting to Count, Count Distinct, and Max/Min.
Also tried setting Distinct in the query settings.