Hi guys,
What’s the best way to take a specific set of rows from another table and process that data before displaying it?
For example: Take the last 4 weeks sales records, then sum or average that filtered data
I can use FILTER or SELECT to get the list, and I can process the data line-by-line with an action, but that’s daft.
I can’t automate the process because the data is manually entered, outside of AppSheet (it comes on a PDF that I have no power to alter).
Is there a better way?
You may wish to further elaborate your requirement to assess feasibility and then possibly community could respond.
For example, is the data in another table accessible to the AppSheet app? Are you always looking for last four weeks data and or desire to have some filtering on the fly but in that case how you expect the filtering parameters to be decided. What do you mean by specific set of rows? By snapshot do you mean SNAPSHOT() function in AppSheet? When you mention “before displaying it”, do you mean before displaying it in PDF report or displaying it in a specific app view?