Aggregate and calculate data statistics using spatial intersect

[hhkaos]

Check existing issues

• [X] I have checked for existing issues to avoid duplicates.

Execution profile

Popup

Is your feature request related to a problem? Please describe.

I would like to display a dynamically calculated value (e.g. an average temperature) based on the aggregate values of several points features within a polygon feature (e.g. weather stations within a county).

Describe the solution you'd like

I expect something simple like this, where the temperature value of all weather stations within a county have been calculated on-the-fly:

Describe alternatives you've considered

The only option that comes to my mind is to write custom code

Additional context

This was a demo shown during the last developer summit (2023), so the county layer that was used can be repurposed.

Note: I noticed there is a similar expression made for the Dashboard profile, but in this case it is used to generate a chart.