Export table as csv created with data expression

[Juan_FelipeVillegas]

Would be great to be able to export data from dashboards,that were generated from multiple FeatureSets using data expressions.Data would be exported as csv.

[MajidAlabrawi1]

hi @Juan_FelipeVillegas , 

i am sure you can find this in arcgis enterprise 11.1 also AGO 

check this Download data—ArcGIS Dashboards | Documentation 

[Juan_FelipeVillegas]

hi @MajidAlabrawi1 

 At the moment it will just work for hosted feature layers as you are problably mentioning, but not for featureSets that are generated with arcade data expressions. In this  particular case there are not options to download the data.

[GarethBaker1]

The link referenced above confirms that downloading is not currently supported on data generated from data expressions. I guess this is because there could be some quite complex logic pulling data from multiple sources and it would be harder to check all those have export enabled.

Would be a very useful addition to support this.

[KPyne]

+1 this is really the functionality I was looking for when after data summary download was added. We can download the layer data easily enough, what would be great is if we could export custom feature sets (summary table, not the source datasets)

[PatrickJ2]

This is the number one thing users of the Dashboards I built have been requesting. I built custom tables for them with expressions to view on the dashboard and they want to be able to export it and add it to other reports. 

[ReubenWolff]

This would be extremely helpful.

[ReubenWolff]

I believe that I have found a solution.

It involves using the ArcGIS Online Assistant to edit the dashboard JSON. I have used the ArcGIS Online Assistant before with mixed results. I strongly suggest that you make a copy of your dashboard before making these edits. I have only tested it using Tables that display arcade generated features. I offer no guarantees.  Here's the process that I used:

First get the item id of the dashboard and the name of the table (Edit Dashboard: Table: General: Settings: Name).

Then open ArcGIS Online Assistant https://ago-assistant.esri.com/ and log in.

• Enter the item id of the dashboard into the Search and click enter.
• The search results should only show the one dashboard.
• Select 'I want to View an items JSON'.
• Click on the search results to open the JSON.
• Scroll down to the Data Section.
• Click the pencil icon to edit the JSON
• I use the Chrome 'Find' to search for the Table Name.
• If it finds the table I then scroll down to find:
  • "returnDistinctValues": false,
    "allowSourceDownload": false,
    "allowSummaryDownload": false
• Edit this to:
  • "returnDistinctValues": false,
    "allowSourceDownload": true,
    "allowSummaryDownload": true
• Scroll back up to the top of the Data Section and save your edits.
• Open your dashboard and the table should now have the 3 dots.

This is working for me for both privately and publically shared dashboards.

I hope it works for you.