Sum values based on criteria

ZackBradford — Wed, 10 Jun 2020 19:07:14 GMT

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
1	2
2	100
5	6
2	35

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?

Re: Sum values based on criteria

DougBrowning — Thu, 11 Jun 2020 16:36:43 GMT

Are the counts in a related table? If so you can use Arcade FeatureSet to go grab them and get a count.

Hope that helps not sure based on the post

topic Sum values based on criteria in ArcGIS Survey123 Questions

Sum values based on criteria

Re: Sum values based on criteria