https://community.esri.com/t5/arcgis-survey123-questions/report-templates-showing-survey123-analyze-results/m-p/1029385#M32664 <P>I have been struggling with how to create report syntax for percentages. I don't see anything in statistics that can give me an example of how to do it.&nbsp;</P><P>In short...is there a way to put the results shown in Survey123 Analyze into a report?&nbsp;</P><P>I want to be able to show the percentage for each category in a question into a table. For example, how many people selected A (%) or B (%) for question 1.&nbsp;</P><P>I'm really struggling to understand syntax. Like this one for example:</P><P><STRONG>Total record count: </STRONG>${Survey|where:"1=1 !important"|stats:"count,objectid"}&nbsp;</P><P>What does the 1=1 stand for? What does !important really do?&nbsp;</P><P>Thanks for your help.&nbsp;</P> Tue, 23 Feb 2021 00:47:53 GMT Jen_Zumbado-Hannibal 2021-02-23T00:47:53Z https://community.esri.com/t5/arcgis-survey123-questions/report-templates-showing-survey123-analyze-results/m-p/1029385#M32664 <P>I have been struggling with how to create report syntax for percentages. I don't see anything in statistics that can give me an example of how to do it.&nbsp;</P><P>In short...is there a way to put the results shown in Survey123 Analyze into a report?&nbsp;</P><P>I want to be able to show the percentage for each category in a question into a table. For example, how many people selected A (%) or B (%) for question 1.&nbsp;</P><P>I'm really struggling to understand syntax. Like this one for example:</P><P><STRONG>Total record count: </STRONG>${Survey|where:"1=1 !important"|stats:"count,objectid"}&nbsp;</P><P>What does the 1=1 stand for? What does !important really do?&nbsp;</P><P>Thanks for your help.&nbsp;</P> Tue, 23 Feb 2021 00:47:53 GMT https://community.esri.com/t5/arcgis-survey123-questions/report-templates-showing-survey123-analyze-results/m-p/1029385#M32664 Jen_Zumbado-Hannibal 2021-02-23T00:47:53Z