Hi Community,
So, I don't think this is a possibility in Experience Builder, but I thought I would ask just in case.
I have built a map with multiple layers of polygon, each representing different datasets. I have created a search function for users to search for a locality. I have a Near Me widget that shows all the different datasets that fall within that searched zone. I then created a query and text with dynamic content, as I was trying to get statistics of the dataset (polygons) that fall within the searched zone. But all I seem to be able to do is Sum, count, average etc for the entirety of the datasets. However, what I am wanting is to get statistics of the datasets for only the sections found within the searched zone.
Hopefully this makes sense...but if not, this image might help.

A user searches the area highlighted in blue above, however they want to know how much of the yellow polygons (circled in red) extend into the searched area (highlighted in blue). So, the yellow polygon on the right might be 100 hectares in total, but only 20 hectares or 20% is within the search area.
Is this a possibility using widgets or coding with experience builder?
Thanks in advance if anyone was able to get through all this, understand it, and provide some feedback 🙂
Matt.