Hello! I need to get a sum of some features. Please have a look at the picture, it is maybe easier to understand what I need.
I need to get a sum of these houses therea are in the different parts of city. The problem is that the name and amount of streets are allways different. I do not know how to automate it.. Any ideas?
Best answer by rileym
Hi @tereziastredna
Have a look at the documentation for the Aggregator and StatisticsCalculator transformers.Both allow you to specify a 'Group By' attribute and can sum the values of the attribute you group by.
In this case I'd recommend Aggregator to sum the values of your left/right hand values to street level. You could then place another Aggregator to sum the values of streets to neighbourhoods.
Hi @tereziastredna
Have a look at the documentation for the Aggregator and StatisticsCalculator transformers.Both allow you to specify a 'Group By' attribute and can sum the values of the attribute you group by.
In this case I'd recommend Aggregator to sum the values of your left/right hand values to street level. You could then place another Aggregator to sum the values of streets to neighbourhoods.
+15Actually I don't think either of them can yield the result in your picture...;)
Actually I don't think either of them can yield the result in your picture...;)
+15@tereziastredna
..it was a joke...
no transformer will get you 5+8 =15...
You need some change to mathematic fundamentals for that.
@tereziastredna
..it was a joke...
no transformer will get you 5+8 =15...
You need some change to mathematic fundamentals for that.
