I have a Organic Groups structure of:
I can use views to show all of the properties within an organisation by setting a contextual filters with OG membership: Group ID.
What I want to be able to do is count the number of open claims (a claim where a feild 'status' is set to 'open') within a property. For example:
Is this possible using views? It seems to ask a lot of views as I guess I need a subquery or second query to get the claims of each property.
Each claim references a property in its group audience feild. Each property references an organisation in its group audience feild.