I wonder if you know what the following issue is with this new problem I’m faced with the expression.
I’ve reorganized my table in google sheets so that “RIDE” and “INDOOR BIKE TRAINER” share some similar columns instead of all exclusively separate columns which I had done in the past. When I try the formulation below, I don’t seem to be getting the same result in terms of ordering the DISTANCE column from Lowest to Highest which is what I’m looking for. It seems that there is no order at all. The ACTIVITY = “RIDE” seems to work (as it does not include any INDOOR BIKE TRAINER activities but there’s no order in the DISTANCE column like before. Here’s a screen shot of the table: Distance is not in any order. I wonder what’s change? Any insights or articles on how to solve for this?
Expression Used (per your original suggestion):
FILTER(“ACTIVITY DATA”, [ACTIVITY]=“RIDE”),
This expression comes back all TRUE and it worked before but not in this new way.