I have two labels Searchable and Unsearchable on one of my node...
Right now I have only Searchable nodes... So wanted to get counts of Unsearchable and assume that I will get 0. So my query was
optional match (c:Country) return count(c) as countries, count(c:Unsearchable) as unsearchableCountries
i assumed result should be
countries: 10 (as I have 10 countries marked as Searchable) unsearchableCountries: 0 (as right now i have no Unsearchable country)
but I get 10 for both the values.
Can someone please help... what I am doing wrong?