Howdy! I am trying to create a series of inventory counters in ArcGIS Dashboards on ArcGIS for Enterprise 10.9.1. The inventory is of refuse carts of three types recycle, trash and yard waste, each having up to three sizes (35, 45, and 95 gallons). I was considering starting with a supply of carts, a number, then subtract from it each time a cart of that type and size is pulled from inventory and the delivery is completed. For example, I have 100 95 gallon recycle carts (R95). I pull three from inventory and deliver them. I would like a counter that shows 97 R95 carts remain. Each time I pull a R95 cart(s) from inventory, the count decreases. We use Survey123 Connect to record and manage the various cart transactions. I have a Delivery Complete field (yes, no) in the Survey form. My thought process was to use Arcade, sum the number records for Delivery Complete (=Yes), filtered by cart type and size, and subtract that count from the starting inventory value for that cart type and size. As the Delivery Complete value increases, the remaining cart count decreases. Does this approach make sense? If yes, I am struggling with coding the idea in Arcade. Or is there another way to achieve a dynamic inventory count?
