ArcGIS Experience Builder Import large table to display results of customer survey

JonathanHall3

I wonder if it is possible to import 1 large table into an ArcGIS Experience Builder Project, which will hold the data for a number of charts I intend to create to display the results of a customer survey.  Instead of importing say 20 individual tables, each table showing the results of a single question. The data table will not be related to any map.  Each page of the Experience Builder website will show the results for each topic area in the survey, with 4 or 5 questions for each topic area.  I presume the main data table would need to be laid out in a way that would enable the results for each question to be pulled out and used in the various table and chart widgets?

Shen_Zhang

Hi @JonathanHall3 -You don't need to split a large dataset into 20 individual data. You can create multiple data views using a single data as the data source. For each page, you can create a data view from the original data so that it can display results for a specific topic area in the survey.

I believe this should work but the "big table" should include columns or fields that clearly label the survey question or topic area, so you can use expression builder to extract relevant subsets for each visualization.