topic Using Repeats Survery123 in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/using-repeats-survery123/m-p/771877#M4005 <HTML><HEAD></HEAD><BODY><P>I want to calculate the % cover of a vegetation transect, and have the % cover update as different points are analyzed. </P><P></P><P>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).</P><P></P><P>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.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 17 Jul 2019 20:23:25 GMT Anonymous User 2019-07-17T20:23:25Z Using Repeats Survery123 https://community.esri.com/t5/arcgis-survey123-questions/using-repeats-survery123/m-p/771877#M4005 <HTML><HEAD></HEAD><BODY><P>I want to calculate the % cover of a vegetation transect, and have the % cover update as different points are analyzed. </P><P></P><P>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).</P><P></P><P>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.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 17 Jul 2019 20:23:25 GMT https://community.esri.com/t5/arcgis-survey123-questions/using-repeats-survery123/m-p/771877#M4005 Anonymous User 2019-07-17T20:23:25Z Re: Using Repeats Survery123 https://community.esri.com/t5/arcgis-survey123-questions/using-repeats-survery123/m-p/771878#M4006 <HTML><HEAD></HEAD><BODY><P>Hi Kristen,</P><P></P><P>Survey123 supports the overall aggregation statistic capabilities through functions such as sum() and count(); the average is</P><P>sum(${q}) div count(${q})</P><P></P><P>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. &nbsp;You then can use a count() function with that hidden question.</P></BODY></HTML> Wed, 07 Aug 2019 17:11:00 GMT https://community.esri.com/t5/arcgis-survey123-questions/using-repeats-survery123/m-p/771878#M4006 JamesTedrick 2019-08-07T17:11:00Z