How to print specific fields in a view? I have 3 content types:


Country
Destination
Attraction


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!
try:

under Advanced Tab, create a relationship. the type will depend on your field names exactly, but if the view is for the country, you should be able to find the destination and attraction fields available.

the new related fields should show up now in your Fields list and you can add them to the view

For the count, try the following:

Entity Reference Count
or
Entity Reference Calc
or take a look at this on SO