Merge/Aggregate Survey123 from responses for Ops Dashboard

[GavinTaylor1]

Hi

I have setup a number of survey 123 forms with the identical set of questions for different operations (8) in our company. I would like to dynamically aggregate the results into a single table/view so that I can setup a dashboard showing aggregated data as well as data by operation. Is this possible? I cannot figure out how to do this with ArcGIS online. Or is there another approach I should be considering?

Thanks in advance.

Gavin

[JamesTedrick]

Hi Gavin,

Apologies for the delay.  It isn't possible to automatically add the records of different tables together - you could append the data from the tables into one feature layer.

Another technique would be to have the forms all submit data to the same feature service - that way, you would have one table receive all the records, which could then be used to display the results in other applications