I am trying to create a Survey123 report based on the Esri Damage Assessment solution Individual Assistance Survey. The issue is that I am trying to group the results by county name and I need counts of records that meet a criteria. I can successfully create a repeat row that returns counts or sums of numeric fields, but I can't seem to figure out how to get a count of each category in a column.
For example, I can sum all the units in the field "impacted_units". But, on the same row I want each cell to be filtered differently based on several criteria. That way it would sum the TotImpact differently based on attributes for each cell.
${#Damage_Reports | stats:”sum,impacted_units,TotImpact”:”county_label”:”” |where:”a1=1” | orderByFields:”county_label DESC”}${county_label} | How do I get a count of all 'Single-family', 'owned', 'damaged' residences etc. | ${TotImpact}{/} |
I don't see a way in any of the documentation or blogs to filter by categorical information in columns several different ways. I could modify the where clause for one cell, but not 30 different criteria for 30 cells. I am hoping someone can prove me wrong. Attached is the word format report I am trying to complete.