Latest Contributions by AmyRoust

I'm having trouble conceptualizing what I need to write in an Arcade statement. Here is a fake table that mirrors what I'm working with: Year Program_Type Fed Fund 1 Fed Fund 2 Fed Fund 3 Local Fund 1 Local Fund 2 Local Fund 3 Local Fund 4 2015 Program Blue 0 0 0 5000 100 0 0 2015 Program Red 10000 9000 1000 1000 0 0 0 2016 Program Green 0 17000 0 3000 0 0 0 2016 Program Purple 0 0 5500 5500 5500 0 1700 2017 Program Orange 6500 500 0 1200 800 0 0   I need to return a table that looks like this: Year Fed Funding Local Funding 2015 20000 100 2016 22500 7200 2017 7000 2000   The goal is to have a pie chart in a dashboard that compares combined Federal Funding to combined Local Funding. The default view will be all years combined, but I need the pie chart to update when the dashboard filter is set to a specific year. Bonus points if I can figure out how to add a definition query to the table's results that allows me to filter out specific program types (e.g. add everything up as long as it's not from Program Orange). I can handle that part by creating a view layer from my hosted table, but if I can build it into the query, so much the better. Fewer items to manage in AGO. I've gotten far enough that all of the values are added up, but I cannot get my mind wrapped around adding in the Year option. // Fetches features from a public portal item var fs = FeatureSetByPortalItem( Portal("https://xyz.maps.arcgis.com/"), "xyz", 0, ["Program_Type","Fed Fund 1", "Fed Fund 2", "Fed Fund 3", "Local Fund 1", "Local Fund 2", "Local Fund 3", "Local Fund 4"], false ); var fedtotal = Sum(fs, "Fed Fund 1") + Sum(fs, "Fed Fund 2") + Sum(fs, "Fed Fund 3"); var localtotal = Sum(fs, "Local Fund 1") + Sum(fs, "Local Fund 2") + Sum(fs, "Local Fund 3") + Sum("Local Fund 4"); var total = fedtotal + localtotal var fed = round(when(fedtotal=='NaN', 0, fedtotal),2) var local = round(when(localtotal=='NaN',0, localtotal),2) return FeatureSet( { fields: [ { name: "Federal", type: "esriFieldTypeSingle" }, { name: "Local", type: "esriFieldTypeSingle" }, { name: "Total", type: "esriFieldTypeSingle" } ], features: [{ attributes: {Federal: fed, Local: local, Total: total} }] } );     ... View more

Is it possible to use Arcade inside an element on a dashboard? Or do I need to do the math in a web map and then refer to that field? Here's what I'm trying to do (fake data for illustration): Fed Source 1 Fed Source 2 Local Source 1 Local Source 2 Local Source 3 $999 $999 $444 $444 $444 $523 $231 $123 $153 $9751 $6237 $94086 $0 $0 $0 $0 $0 $992 $1000 $904   I want to create a donut chart that shows the percentage of federal funding versus local funding. My thought was that I could write an Arcade statement to add up Fed Source 1 and Fed Source 2 and call it FED, then write an Arcade statement to add up Local Source 1, Local Source 2, and Local Source 3 and call it LOCAL. I'm not seeing any place inside Dashboards where I can do statements like this, but I thought I'd ask to be certain. ... View more

I'm setting up a process to download attachments from several feature classes before deleting them from the database. The feature class and the attachments table are branch versioned. As near as I can tell, there is no way for me to batch delete attachments, either with the Remove Attachments tool or the Delete Rows tool. Am I missing something? I tried publishing a service with the attachments table in it, but it doesn't appear in the service. ... View more

I'm struggling to find detailed documentation or training on trace networks, so I hope someone here can provide guidance. I have two utility systems (stormwater and potable water) that both have their own trace networks. Let's just use stormwater as my example. In case it matters, we are using branch versioning. The stormwater trace network has 8 feature classes that participate:   I need to add a field to ssManhole, ssValve, and ssFitting. If I add this field, what happens to the trace network? Do I need to rebuilt topology? Do I need to create a completely new trace network? Or will the trace network ignore the new field since it has nothing to do with flow or connectivity? (It's a text field that will hold a URL to a folder with photos.) Side note, if there are any classes on trace networks, I'd love a referral. I've search esri.com/training but haven't found anything. The online documentation makes it seem like trace networks are very simple and straightforward, but my experience with Esri behaviors in the past suggests otherwise! ... View more