How to update the source table of a dashboard chart without destroying the settings

RobertBuckley1

I have to change the table of a dashboard chart every time I receive new statistics. How can I do this without having to totally reinstall the chart?  If I pick a new source table, the chart settings are reset.

kenbuja

You can use the ArcGIS Online Assistant to do this. First, I would recommend making a copy of your dashboard. Once you've logged on, under "I want to..." select View an Item's JSON, then select your dashboard copy.

In the Data section of the JSON, look for the chart and you should see an entry for the dataSource (similar to this)

<SPAN class="string token">"dataSource"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
  <SPAN class="string token">"type"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"featureServiceDataSource"</SPAN><SPAN class="punctuation token">,</SPAN>
  <SPAN class="string token">"itemId"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"</SPAN><SPAN class="punctuation token">,</SPAN>
  <SPAN class="string token">"layerId"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN>
  <SPAN class="string token">"table"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">false</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Change the itemId to the new table and save it.