Recover Dashboard Configuration Settings in case of corruption
When overwriting AGOL tables/layers from ArcGIS Pro there is sometimes a problem where the table or layer being overwritten becomes corrupted. This is a big problem in Boulder County’s Vaccination Dashboard because so many gauges and charts rely on one table. https://bouldercounty.maps.arcgis.com/apps/dashboards/3a486aa2faa441fa8d6dadb45c78e240
Enhancement Request -- Ideally, if a table gets corrupted ESRI could just allow repointing to a new table without wiping out all the configuration settings for each gauge/chart -- similar to when a layer in ArcGIS Pro or ArcMap has the underlying Feature Class renamed. In those cases you can repoint the layer to the new data source and all of the categories/symbology that had been set up is retained after repointing.
In the Boulder County Vaccination Dashboard 40 gauges rely on one table, and 5 serial charts and 3 other elements rely on another table. But all that is multiplied by 4 since there are four versions of the dashboard (Desktop, Mobile, Spanish, Desktop Test). So there are actually 32 charts/elements that rely on one table and 160 gauges that rely on another table. Here is a screenshot showing just a few of the gauges (there are many more gauges and serial charts in the dashboard)
Unfortunately, when an AGOL table gets corrupted when overwriting from Pro you have to create a new data source (table) and then repoint the gauges/charts to that new data source. That part is not too bad, but what IS bad is when you go into the dashboard and repoint the gauge or chart all the configuration information is wiped out and you have to redo the configuration for each of the gauges and charts. That would be bad enough to do for 160 gauges or 32 Charts, but what is even worse is that you no longer have any reference as to what the configuration should be for each gauge or chart. So you either need to remember or figure it out all over again… which depending on the specific circumstances can take from several hours to a full-day to do.
This (a table being corrupted in the overwrite process) has happened to me twice in the last year. The first time it took about nine hours to reconfigure all of the gauges in the four dashboards. The second time it took about six hours to reconfigure the serial charts.
