I have a point layer that displays overlapping points at the same location (many different categories and over multiple years). I want to create an average number for the overlapping points for the same categories. The data table is set up so that overlapping points can be identified as the same category when 'Site', 'Section' and 'Complete' fields are all the same.
For Example:
Point ID Number Site Section Complete Average_attribute
1 10 Red Circle Yes 22.5
2 35 Red Circle Yes 22.5
3 14 Red Square No 10.5
4 7 Red Square No 10.5
5 6 Red Square Yes 6
6 15 Green Triangle Yes 15
How can I create an average attribute expression in the pop-up, with the average number shown like the above example?
Thank you!
