Pull Data Out Statistics Not Returning Any Values

TheoHorton

I am using pulldata in survey 123 calculate column to sum the number of entries in a layer under the same feature service but filtering by an id (patrol_id) selected in the survey. I can see this is possible and survey123 is not returning any issues with the syntax but no values are being returned when there should be. 

I am using the following syntax: 

pulldata("@layer", "getValue", "attributes.sign_count", concat("https://services7.arcgis.com/ljSgek0qJg42y4Ln/arcgis/rest/services/QCT_Patrols/FeatureServer/1",'?outStatistics=[{"statisticType":"count","onStatisticField":OBJECTID","outStatisticFieldName":"sign_count"}]'), concat("patrol_id = '",${patrol_id},"'"))

 

I am unsure why it is not working. 

Any help would be greatly appreciated. 

qct_patrol_summary.xlsx

Ling_Tang_ESRI_Imagery_1-1743726714314.png

Neal_t_k

Pulldata doesn't do well with calculation inside them.  Try pulling out your two concats calculations into helper fields.