In the print composer when generating an atlas, does anyone know how to show he feature count per each atlas coverage feature?
For example, I have generated an atlas where each map is a different province (in Cambodia) containing a village point layer. When I click the sigma sign at the bottom of the legend for villages, the feature count will calculate the entire country's number of villages, not for the individual province's number of villages.
Does anyone know how to get a feature count in for the province showing in the atlas?
Best Answer
This works for me: use the
aggregate()expression in a text label, withwithin($geometry,@atlas_geometry)as a filter for points within your atlas feature.The full syntax in your text label would be
That will count all the points in your specified layer - by an unique non-null attribute, so each point is distinct - but only if the point geometry is within the atlas geometry.
The [% %] is required to make the expression work. And note the quotation marks - you must use double quotes for the attribute name.
As a bonus you can add further filters, so to address one of the comments above, you can modify the filter to say
within($geometry,@atlas_geometry) AND "village" = 'A', or whatever combination.I haven't extensively tested this out, especially on large/complex datasets, but it seems to do the job.