I have a Label named 'City' assigned to 10 nodes i.e. City1, City2, City3.... City10.
Each of these 10 nodes have properties like Park, Market, School, Hospital, Court, Population etc but having different values, like for some cities if there are no Hospital & Park then their properties are defined as:
Park = "no", Market ="yes", School="yes", Hospital="no", Court = "yes", Population= 100000
Similarly, if for some cities there are no Market, Hospital, Court then
Park = "yes", Market ="no", School="yes", Hospital="no", Court = "no", Population= 5000
So, basically, the idea is each city has different properties values.
My objective is, from among these 10 nodes, i need to select a given city & calculate a metric based on below steps:
Step1: First Count those properties for which value is "yes" (Similar to COUNTIF in Excel)
Step2: Additionally, check whether population of these cities is greater than
some threshold(say, 3000) and then
Step3: Use Count from Step1 and result from Step2 to calculate a metric(some math operations)
Can you please share how can we build such a Cypher Query.