Latest Contributions by AmyRoust

I love using SQL views to summarize my data for use in Dashboards and Experience Builder. However, I keep running into the problem of not having a unique identifier for Pro to use. Here's an example query: SELECT CONTENT_AREA, COUNT(CONTENT_AREA) AS Count FROM SDE.Dataset GROUP BY CONTENT_AREA   That gives me a nice table that looks like this: CONTENT_AREA Count Metric1 99 Metric2 2 Metric3 73   This query gives me the numbers I need, but Pro can't add it to the map because there is no unique identifier. In other queries that don't use the GROUP BY clause, I can use this trick:   CAST(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS INT) AS OBJECTID   ... but this doesn't work in Pro unless I include OBJECTID in the GROUP BY clause. ... View more

This is a request to enhance how the List widget action behaves when a user clicks on a location in the Map widget. When you click on a location in the map, the List widget is set to draw a heavy black box around the associated card for that location. However, the List only scrolls up far enough to get that selected card at the bottom of the List. I'd like to have the List widget scroll up far enough that the selected item is at the top of the List. While testing the UX with people in my organization, the consensus was that they did not know that they needed to scroll down to find their selection. They wanted it to jump to the top. For reference: I posted this as a question to the Esri Experience Builder Community site. https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-select-in-the-map-widget-should/m-p/1137147 I put in a Help Desk ticket to confirm that the behavior cannot be modified (Esri Case #02990311). Their response: "Unfortunately that is the expected behavior and can't be altered with settings. The list widget only loads a small portion of the data when opening to help with browser loading performance (loading the full list widget will be slow on some computers when loading the experience). As the list widget is scrolled down, the list populates with more data. However, when points are selected in the map which have not been loaded in the list they become the new "bottom" value on the list and show up on the bottom. When the list is fully loaded by scrolling to the bottom first, this behavior does not occur except for "William Newton Hospital" which is the true bottom of the data. The list cannot be reordered when selections are made as it is a reflection of the order of the data in the hosted feature service." ... View more