Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Table with summary information

702 1
cancel
Showing results for 
Search instead for 
Did you mean: 
nRhythm
4 - Data Explorer
4 - Data Explorer

I have a table, and I made a view with some grouping.
Screen_Shot_2021-07-23_at_5_37_09_PM

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.

smiles

1 Reply 1
Eric_Goldman1
7 - App Architect
7 - App Architect

Hi @nRhythm - welcome to the Airtable community!

You could use a service we built, Sync Inc, to do this. We’ll replicate your Airtable base to a Postgres database in real-time. Then you can use SQL (including GROUP BY) to quickly recreate this view and summary analytics.

Would be more than happy to walk you through it - just shoot me a DM :slightly_smiling_face: