Using Repeats Survery123

501
1
07-17-2019 01:23 PM
by Anonymous User
Not applicable

I want to calculate the % cover of a vegetation transect, and have the % cover update as different points are analyzed.

a) is there a way to reference what repeat # I am on? (for example, say at point 1, there is veg cover; and the end of repeat 1 I want to show "100%" cover; and then at point2, if there is not veg cover, the calculation should say 50% cover, etc).

b) Can I do "count ifs" across repeats in survey123? I have a select-one question, and I want to be able to count across repeats the different answers.

Thank you!

Tags (1)
0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

Hi Kristen,

Survey123 supports the overall aggregation statistic capabilities through functions such as sum() and count(); the average is

sum(${q}) div count(${q})

One way to do a 'count-if' is to have a hidden question in the repeat that does the if statement returning the value you want if true and 0 if false.  You then can use a count() function with that hidden question.

0 Kudos