I have been wrestling with this for a while and I can’t seem to do what I feel like should be a very simple operation.
General idea is, I am trying to sort a list of races based on split times
Very basically, I have a list of data types where each entry has a series of fields as dates. In my case, it looks like this:
Start = Date
Marker 1 = Date
Marker 2 = Date
Marker 3 = Date
For easy visuals I want to rank/sort individual split times into a form of leaderboard. For this I have a repeating group that searches for a list of races filtering out for certain parameters (i.e. do both data points exist such that a split time could be calculated). With that list I want to apply a sort based on the difference between two of the fields. So I imagine it would look something like this:
For first marker split:
Search: List of Races
Sort: Marker 1:extract Timecode - Start:extract Timecode
The “Calculate Formula” option doesn’t have an option for generic math operations, and Ranking is looking for a single outside point of comparison.
If I could sort by a value in a cell, this would be totally solved, but that’s not doable.
I could create a new field for each split that I want to make and add it as part of the workflow, but that seems incredibly excessive for this purpose.
What am I missing?