I'm doing a neo4j project.
I'm trying to use the avg() function in a property of a relationship
This is my query:
WITH C.price as contractPrice
I have this graph:
Blue Label is an Entity, and Orange label another entity. CONTRATO has the informations about a contract that both entities have made with each other
I have this query that basically calculates the average of the s...
Hi. Recently i've posted a query(then solved) that was to sum string values, and if a label was upper that value it was returned like some kind of fraudulent entity.
Here's my query:
Match (e1:ENTIDADE) -[c:CONTRATO]->(e2:ENTIDADE)
With e1, sum(toflo...
I'm new in neo4j and i have a question that i've already tried to solve but nothing.
So, i'm doing a graph and at certain point i have to sum values that i have in a json file, but the value of the field is in string. Here's what i have:
I have a json file on this path: C:\Users\Joao\Desktop\ProjetoFinal8150133\DadosExtraidos\new.json
When i try to invoque:
in Neo4j, it says:
WITH C.price as contractPrice, E1, E2
WITH collect([E1,E2,contractPrice]) AS costRecords, avg(contractPrice) AS avgContractPrice
WITH [record IN costRecords WHERE record > avgContractPri...
I've solved it.
This was the solution:
WITH eante,sum(tofloat(replace(replace(C.Preco,".",""),",","."))) as sumPreco
WHERE sumPreco >50000