Hello, Im trying to group airtable data to use in charts. I can’t use bubbles group by feature since its an external data source.
Has anyone used airtable and know how I can make charts based on in there?
Example: I have sales data and i want to show sum of sales by month in a bar chart.
Hi, you can actually use the :groupby feature with external data source but you have to do the API call to get a list of results you can then group by month if you have a date field and aggregate.
e.g. with an API call to the Algolia API with a list of hits:
Ohh I see. Would you mind explaining how I do that in a quick loom? I am very new to bubble
Just make the api call to get the data, but make sure you make the call type as DATA not action. it will give you a content type to choose in elements and you can use get external data to call that api call and get the data. then use grouped by to group them by a field.
See if still stuck, ping me i will help you @dan37
thanks will take a look into it and let you know!
@Baloshi69 we’re still a little lost here. Any guidance would be super valuable
Can’t you do the rollups in Airtable and then bring the grouped data to Bubble?
when you be online ping me on linkedin or whatsapp , see my profile will love to help.
