Having some conceptual trouble creating a View to list users that have nodes containing entity references Users on my site can create content by adding a new node of content type 'project'.

Projects are assigned to exhibitions through a drop down 'exhibition' field which is an entity reference to another content type named 'exhibition'. 

Exhibitions are created by admins and each exhibition has a location field (one of three distinct values).

I would like to create a view that displays all users that have created projects for two or more locations. So that could be (for example) 5 projects for 2 exhibitions in location X and 2 projects for 1 exhibition in location Y.

Having some conceptual trouble putting the view together, any help much appreciated.

Danny.
Got around my mental block.


Created a 'Users' view. 
Added an 'Entity Reference: Referenced Entity' relationship.
Turned on aggregation for my view
Added the field I wanted to count and selected COUNT (distinct)


Working well now.

Danny.