Need assistance trying to sort a repeating group by a list of items:count
I have “Driver” type and each “Driver” has a list of “Driver_Violations”
When I display this in a simple repeating group I am getting the data I want, however, I cannot seem to sort the list by “driver_violation” count. I need it sorted with most violations decending. I have tried a dynamic field to search but no luck so far. this is how it is currently displaying:
This is the Driver Database table:
I see a lot of Bubblers with the same issue and yet there doesn’t seem to be a solution.
I could create another field with a number type and add up, problem is I need to then also filter it by daily, weekly, monthly so a static number field won’t work for this.
Any help appreciated