I have an asset inspection app and have been using the following expression to get the most recent inspection result for a particular “asset id”:
([_THISROW] = MAXROW(“inspections”, “timestamp”, ([Asset_ID] = [_THISROW].[Asset_ID])))
Works perfectly.
Now I have learned that “Asset ID” is not unique, but may be repeated in a different category, e.g.
“asset 5” could appear within different categories as shown below. This is due to a legacy numbering system.
[category][subcategory][asset id]
Electrical > Tools > asset 5
Vehicle > Offroad > asset 5
IT > Laptop > asset 5
So what i would like to do is modify to:
([_THISROW] = MAXROW(“inspections”, “timestamp”, ([category][subcategory][Asset_ID] = [_THISROW].[category][subcategory][Asset_ID])))
but the appsheet help guide says this can’t be done.
Is there a solution to this?
Is the solution to create a computed column, combining all those fields
User | Count |
---|---|
43 | |
26 | |
23 | |
16 | |
11 |