I have 3 content types:
Each attraction has an entity reference poiting to Destination. Each destination has an entity reference poiting to Country.
I need to create a view in a block, published on all content types Country that lists all Destinations within that country and the number of attractions within each Destination. For example, France destinations are Paris and Marseille. Paris has Eiffel Tower, Louvre and Pont Neuf as attractions. Marseille has Chateau d'If and Panier as attractions. In my country node I should be able to print: Paris (3) Marseille (2) I only need the title and that particular number, with links on title going to their specific nodes.
How could that be achieved? I was thinking about aggregation but I have tried to do so and failed. Thank you!