I am trying to build an app in experience builder of my organization's current grant projects. I have them all on a map as point files, within the attribute table there is a column of "% compete" based on how much of the grant funding has been spent so far (updated each fiscal quarter). I want to have a gauge widget in the corner that only displays the percent completed for whatever project is selected either from the map itself or from the list widget also within the experience, but I cannot get it to display anything other than sum/count/min/max of the entire column, and not just one of the selected items.
Any help would be appreciated
