Aggregation (Join) Calculations

Question

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!

dfinkbeinerTMEE · Answer

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.

dougbrowning · Answer

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