I'm using QGIS 2.18.16. I have a layer with 100k locations, each with several values in the attribute table (ex: mass, E impact, v, ...) for each point (imported via CSV file). I use a vector grid to count the number of spots for each square of 5m by 5m = ok so far. This gives me a heatmap of the number of hits.
I would like to add to each square an average of another value of each spot. (from csv file and in attribute table of hits layer) Ex: square A, has 250 hits(= individual values) those are already counted. But those hits in square A have each a different Energy impact. I would like to get the average E impact of these hits in each square for the same vector grid. This gives me different heatmap in the same vector grid. Not with the number of hits per 5x5m square but with the averag E impact.
The final goal is to generate a final layer by multiplying 2 or more values (number of hits, average E impact, presence of people, ...) for each same 5x5m square to obtain a final kind of heatmap that combines those factors for each 5x5m square.
Can this be done?