Latest Contributions by AmyRoust

I'm struggling to interpret Esri's instructions for generating a pick list from a feature service for a select_one question in Survey123 Connect. I'm referencing the Search function. Here's what I'm getting from the documentation: In the choices tab, enter the list name (doesn't matter what I call it), the name (must be the field name in the feature service that I want to pull values from), and the label field (doesn't matter what I call it). Here's my config:   Then, in the survey tab, I populate the type as select_one buildingname (with the part after the select_one statement matching the list_name value in the choices tab), the name (with the name of the field in the feature service), the label (does not matter what I put here). Here's my config: Then, in the same tab, same row, I have to populate the appearance column with the search() function and the correct parameters, which are supposed to be search(tableName, searchType, searchColumn, searchText, filterColumn, filterText). I can tell that tableName is the URL of the service (including the number of the sublayer), but after that, I get hazy. Here's what I have so far: That syntax does not actually generate a drop-down menu on the survey. If I add the autocomplete parameter, I get a blank drop-down. Help?     ... View more

I have created a dashboard using data from a hosted table that is published from a Microsoft Excel spreadsheet. The user wants to be able to update the dashboard directly from the Excel spreadsheet that they maintain, which is why I went this route instead of migrating the data management into a geodatabase. Since I had to upload the Excel spreadsheet as an item before it could be published as a hosted table, that copy is still in ArcGIS Online even though I don't need it anymore. I tested updating the Excel spreadsheet's data, and it has no impact on the hosted table. But, when you look at the item page for the hosted table, it tells you clearly that it was created from the Excel file, so I'm unclear on whether that Excel file is necessary or not. What's the best practice for the Excel spreadsheet item? Do I: A. Keep the original Excel file in ArcGIS Online and do nothing with it. B. Keep the original Excel file in ArcGIS Online, and have my user update both the Excel file and the hosted table? C. Delete the original Excel file in ArcGIS Online and only update the hosted table. ... View more

The Share widget has a checkbox to share URL parameters, which works if you uncheck the short URL option. I may be misremembering, but I thought that when you shared a link from Web AppBuilder, it would remember which layers you had turned on. Experience Builder's share widget does not do that. Can anyone elaborate on what the Share widget is supposed to do and perhaps if there are plans to expand its functionality? ... View more

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