topic Aggregation (Join) Calculations in ArcGIS Survey123 Questions

Aggregation (Join) Calculations

dfinkbeinerTMEE — Tue, 08 Feb 2022 13:52:31 GMT

I'm using a join calculation in a hidden field to to return values entered within a repeat to a heading for reference while water monitoring. I'm wondering if it's possible to limit the amount of records that are returned in this join.

For instance we could take 10 records within the repeat but I only need the previous 3 to join and display in the heading at any time.

Thanks for any help!

Re: Aggregation (Join) Calculations

DougBrowning — Tue, 08 Feb 2022 14:17:20 GMT

Are the values about the same size? If using substr(question, start, end). Combine this with string-length and you could always peal off the last X chars from your join for display.

Other idea is to use position and indexed-repeat functions to grab the last 3 values.

Hope that helps

Re: Aggregation (Join) Calculations

dfinkbeinerTMEE — Tue, 08 Feb 2022 15:14:52 GMT

Thanks Doug!

I saw this on another thread and wasn't quite sure if it was what I was looking for. I'll give it a try and report back.