Report Templates showing Survey123 Analyze results

02-22-2021 04:46 PM
Occasional Contributor

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. 

In there a way to put the results shown in Survey123 Analyze into a report? 

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. 

I'm really struggling to understand syntax. Like this one for example:

Total record count: ${Survey|where:"1=1 !important"|stats:"count,objectid"} 

What does the 1=1 stand for? What does !important really do? 

Thanks for your help. 

Jen Zumbado-Hannibal, GISP
GIS Coordinator
City of Forest Grove
Forest Grove, OR 97116

0 Kudos
0 Replies