I have a table, and I made a view with some grouping.
The schema of the table is [Survey, Question, Category, Person, Response]
Now I want to be able to extract the table with those groups and summary statistics and use that elsewhere in another part of my workflow, outside Airtable.
The API allows filtering, but not grouping it seems. How does one accomplish this?
Another option is somehow I can make the summary statistics into their own view/table? so it would look like [Survey, Category, Average Response]? Then I can query for that table and read those records and use them where I need them.