Maybe you could help answer this or point me to the right direction. I have a fictitious data set (table) in google sheets that is being populated by AppSheets shown below.
How would you get specific values that you’re looking for based on this table? For example, if I wanted to find the MAX distance for the AppSheet USER (filtering out users) for ACTIVITY = “RIDE”. Or another example, find out the highest elevation (also a MAX function) for the AppSheet USER (filtering out other users) for ACTIVITY = “RIDE”, etc.
In google sheets, I’ll typically use a QUERY function of the dataset and select the columns and set the parameters of what I’m looking for but I want to explore to AppSheets making these calculations for me instead of taxing google sheets to make the calculations.
Anyways, interested to hear your thoughts.