¿Se puede filtrar el mapa de Excel si el mapa web tiene un filtro establecido?

Question

Primera vez usando este producto.<\/P> Después de geocodificar las direcciones en una hoja de cálculo, compartí el mapa en mi cuenta. No encontré una herramienta de filtro en Capas, así que añadí el filtro en Map Viewer. Sin embargo, no parece que se muestre en el mapa de Excel. Intenté recargar el mapa pero no funcionó. ¿Es esto posible?<\/P>

ShannonCardoza · Answer

Hello @MikeOnzay! I have tested a few workflows here based on the suggested workflow from your comment. Here are my findings -

Workflow 1: If I select features I have 2 options: Filter sheet or Export.

Workflow 2: If I filter a spreadsheet (hide a row/column or delete/add) without refreshing my web page/map the pop-ups and features on the map will NOT update (sync automatically). Once I refresh I see the corrected map. Pop-ups included.

Workflow 3: If I add my data to the map, and make any edits (hide row/column or delete/add) this will not automatically sync but if I re-add my data all is well again. Pop-ups included.

All 3 workflows are what is expected. I suppose this can 'feel' a bit broken but refreshing the web page/map to refresh whatever it is you are looking at is quite the typical workflow. Anyhoo, let me know if I missed something or if you have any other questions on this!

Again thanks for your feedback!

-SC

MikeOnzay · Answer

I understand that there isn't a Create Filter option in the ArcGIS for Excel map. I did discover that it is possible to select features on the map and it will filter the spreadsheet. I was going to say that it's not possible to filter the spreadsheet and have it filter the map, however, when I filter on a column in Excel, while the same number of points are showing on the map, the popup values don't correspond with the filtered Excel rows. A new issue to troubleshoot.

ShannonCardoza · Answer

Good morning @MikeOnzay! Thank you for your question. Can you help clarify what exactly your workflow is? When you refer to filter, do you mean 'apply filter' or 'create a filter' expression? See Apply filters for more.

In ArcGIS for Excel, you can filter/sort when searching for content/feature layers to add to the map. So to answer your question, we do not currently have a tool for 'create filter' expressions as seen in Map Viewer but there may be a workflow using Excel filtering and our ArcGIS for Excel add-in that may work. I will wait for your reply for understand more!

-SC