Hi @Steve
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.
Thanks!
User | Count |
---|---|
43 | |
28 | |
26 | |
16 | |
11 |