I have two data types: ‘Dates’ and ‘Reviews’ as shown.
A ‘Review’ is its own data type but links to a particular ‘Date’.
I display a list of ‘Dates’ in a repeating group, and calculate the average rating of the Date by searching for all ‘Reviews’ related to that ‘Date’, and calculating the average ‘Rating’ (field under each ‘Review’. But since ‘Reviews’ are a different data type I am unable to sort the RG by the average rating.
How can I do this?