We created a survey in Survey123 Connect to enter information for a long-term monitoring program about berries. The data are collected over multiple sites and years. Each site contains multiple plots; at each plots we are collecting data inside 25 quadrats for 3 different species.
The survey contained two forms which are populated by the XLS. The first one contains data about the plot-level information (plot name, date of sampling, average abundance of each species per plot) and the other contains raw data about the quadrat (species, abundance per quadrat). Each time someone completes the survey, one line is populated on the first form and 25 on the second form.
We now want to calculate the average per site,year and species for display in a Dashboard. Ideally we would have a new feature layer that is calculating this average automatically from the Survey123 forms. We have not yet been able to find anything similar in this forum, any pointers would be appreciated!
