My data: 1 polygon layer + 1 point layer
My target: Calculate the number of points and the sum of a field within each polygon using the aggregate function in the QGIS field calculator.
I know I can simply use the QGIS functions
Join attributes by location (summary) or
Count points in polygon but I´m interested in the aggregate function in the field calculator since I don´t understand exactly its meaning.
aggregate('hh', 'sum', "sum_pop")
'hh' - the name of the point layer
'sum_pop' - the name of the attribute field from the hh layer (sum of the population of a point)
I get the sum of the whole field in the attribute table, so each feature has the same value.
How can I change the code for the aggregate function to calculate the sum of a value based on the number of points in each polygon feature and the number of features within a polygon so I get different values for each polygon?