You can just use aggregation, with count or sum.
And to visualize it as graph not as tables you can use virtual nodes with apoc, I wrote it up here.