Hi Everyone,
I have a table called 'projects' that has a field called 'schools' . I want to be able to display the number of unique schools in this field using the Number element in Interfaces.
I can count the record easy enough but the records in the project table may contact multiple instances of the schools so I'd like to display a count of how many unique records there are.
Hope that makes sense
Jason