Sorry if this has been answered. It's hard to know what to search for when you don't know what you don't know. Seems like a basic question, but I can't find an answer.
I have a db with ~10000 nodes... author nodes and book nodes. Authors have a country property. I can run a match that shows the full network of authors, books and connections to coauthors etc. So I can kind of see which authors have worked with which author authors.
What I want to do is show a network where I have countries that have worked with other countries. I.e if 10 authors from the USA have coauthored a book with 3 authors from the UK and 5 from India, say, I want to show that as 3 country nodes in Neo4J with a count of books on the edge.
I kind of managed to do this using APOC merge... but then the merge is permanent so all my author nodes get merged, rather than it just being a temporary view.
Is this possible to do? Can write a query that will aggregate my data into a graph of country nodes without permanently merging my authors.?