I'm essentially trying to incorporate a "sumif" expression (excel) so that the pop-up of a feature lists the totals from all time and continues to update with new information.
We are using a Survey123 form to track the amount of "apples" collected from a specific numbered "box" at every visit. The resulting attribute table looks something like the table below.
|Box Number||Apples Collected at Visit|
I'd like to have a layer with each of the boxes' locations mapped and when you click on the point, it lists how many total apples have been collected from that box (ex: Box 2; total apples collected: 135).
I'd also like it to continue to update that total value as new survey data is submitted.
Is this possible? What is the best set up/process to go about this?