Survey123 select_multiple + Operations Dashboard

FiorellaRodriguez

<\/HEAD>

In Survey123, a multiple choice question is very useful and we frequently use it in surveys. The collected data is useful for making decisions, and to facilitate decision-making it is ideal to see the data graphically. Operations Dashboardis an excellent tool that allows us to visualize data and obtain statistics; however, the multiple choice questions from Survey123 are stored separated by commas and sometimes this causes the charts not to fit the information we want to see.<\/P>

<\/P>

To be able to count the responses obtained with a multiple choice question in an Operations Dashboard chart, we can create hidden fields for each option and help ourselves with an if condition, following these simple steps when creating our form: <\/P>

<\/P>

1. Create the form using Survey123 Connect<\/LI>
2. Create a hidden type field for each of the options in the choice list.<\/LI><\/OL>

   <\/P>

   In the calculation column, enter the if condition where if we select option X it will put a value of 1, and if the option is not selected it puts a value of 0. <\/P>

   <\/P>

   if(selected(${lista}, 'preg1'), 1,0)<\/P>

         If<\/STRONG> from the choice lista<\/STRONG> selects option preg1<\/STRONG> then the value is 1<\/STRONG>, otherwise the value is 0<\/STRONG><\/SPAN><\/P><\/P>The field type bind::esrifieltype<\/STRONG> must be esriFieldTypeInteger<\/STRONG> so that it is identified as an integer number and can be counted in Operations Dashboard. <\/P><\/P>                                                            Choices Tab<\/SPAN><\/P><\/P><\/P>      Survey Tab<\/SPAN><\/P><\/P><\/P><\/P>     Feature layer of the survey<\/SPAN><\/P><\/P><\/P>   3. Share the webmap that is created by default or create a new webmap with the feature layer of the survey                         &nbsputilizing Operations Dashboard. <\/P><\/P>When using series charts , you can categorize by each hidden field of the response options. And in the statistic method use sum so that it counts each 1 entered when selecting the&nbspoption. <\/P><\/P><\/P><\/P><\/P><\/P>Source: Comment by Kade Been and Nick Dierks from the following post Survey Results in Operations Dashboard?<\A> <\SPAN> <\BODY> <\HTML>