Is there a way to calculate the median of several standard land values from the following WMS service of a given map extent? I want to use it as a dynamic text via expression. I am using the Atlas Tool.
For example: 4 Zones in a given map extent (50, 60, 60 and 80 Euro per sqm) result in a median of 60 in my may Layout.
I have tried the following, but without success:
aggregate( layer:='Bodenrichtwert_Bodenrichtwertzone_34cc603d_9bb9_45d5_a63f_0f0fdf8fbaf2', aggregate:=mean("bodenrichtwert"), expression:=$id, filter:=within($geometry,@atlas_geometry) )