Count Unique Values in Repeat Field

Blevins_Mark

How can you return the count of unique values in a repeat?

• Repeat question is geopoint.
• Based on where user clicks on map i am pulling both town and county using pulldata function.
• I then have two questions in parent table...number of locations and number of counties.
• I want the total # of locations, so simply use the count function to get that.
• I want the county count to be unique...so if there are 5 repeat locations, and 3 are in smith county and 2 are in webb county, the count for the county field should be 2.

Thanks

abureaux

Maybe javascript could help here.

Built-in features is a little more annoying, but may still be possible.

I quickly tossed this together:

It excludes the current item, and checks for that current item in a string.

Form 8.xlsx