Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

[SOLVED] Ability to create graphs, charts, maps from data in Airtable database

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
JaniceAtOSA
5 - Automation Enthusiast
5 - Automation Enthusiast

I am interested in linking my Airtable data to create graphs, charts or maps without having to export to Excel. Are there any existing apps I can link to for this feature? If not, Iโ€™d like to see it as a future feature.

Keep up the great work. Really enjoying using Airtable. Thank you!

33 Comments
Vernon_Fowler
7 - App Architect
7 - App Architect

The tagline for Airtable is โ€œSpreadsheet, meet databaseโ€ and one thing we still need spreadsheet applications like Excel and Numbers for is creating these visualisations.

+1 for this to be worked up in a future beta please. :grinning_face_with_big_eyes:

Vernon_Fowler
7 - App Architect
7 - App Architect

@Gwen_Corey A Location data type might help with an interactive map of a trip with photos. :thumbsup:

Ben_Gardner
5 - Automation Enthusiast
5 - Automation Enthusiast

It seems like this is mostly a new feature request, so I donโ€™t know how helpful this comment will be.

But for those of you that have an affinity for front-end web dev: you can fetch data from Airtable using their API and display it using chart.js or another similar javascript library.

Hereโ€™s a working example: https://airtable-chartjs-binarygourmet.c9users.io/chartjs/

And hereโ€™s the tutorial that explains how to do it: http://www.automationfuel.com/airtable-api-example-tutorial/

Full disclosure: I wrote the above tutorial because I saw this thread and wanted to give the project a try for fun.

Trigger_Pappy
4 - Data Explorer
4 - Data Explorer

The APIโ€™s are great. Charts, Graphs and Maps while great are not what airtableโ€™s core value is. IAirtable a backend and you can use the data in other frontends and visualization tools. That said they impressed me whan I asked for a Kanban view just a few months ago they added gallery and the kanban soon after. so there might be more front end views in store. I use airtable with Cyfe for visualizations, there are other options as well if you don;t know programming.

Adam_Amsel1
4 - Data Explorer
4 - Data Explorer

+1 for built in visualizations: pies, scatters, bars, lines, etc.

Iโ€™ve been trying plot.ly, which is pretty compelling, and have considered excel or numbers, but havenโ€™t been able to streamline the process more than exporting and importing a .csv from Airtable.
Can anybody provide a simple tutorial for a non-developer on any solutions that would eliminate the inefficiency of importing/exporting data and allow a dashboard of specified charts to auto-update as Airtable data updates?

Thanks very much.

Benjamin_Yackle
4 - Data Explorer
4 - Data Explorer

Charts/graphs are something Iโ€™d definitely love to see in Airtable - I think theyโ€™d fit most naturally in their own View, with the ability to create Kanban-like โ€œcardsโ€ that draw from specific views in tables. E.g., a scatter plot based on two selected columns, or a histogram of frequencies of entries in a single/multiple-select field. The Lat/Long data type plotted on a map would be an extension of this, and makes me think a natural extension would be to select colors and marker shapes based on other field values for the same points. Airtable could become an invaluable tool for data visualization with something like this added in.

Johannes_Humber
4 - Data Explorer
4 - Data Explorer

Yep! The Data-Extrakt work fully automatet. We are thinkung of using the Product for our Sales Team, but without BI we can not manageโ€ฆ

Johannes_Humber
4 - Data Explorer
4 - Data Explorer

A automatet Data-Extrakt would be so nice. We would love to use the Product for our Sales-Team, but we need BI to work alongsideโ€ฆ we tried the Jason API in combination with Power BI but got only 100 Records. Problem is: we need 24k Records in one Base :winking_face: Keep up the good work!

Julian_Kirkness
10 - Mercury
10 - Mercury

Making the assumption that a starting point could be the creation of charts as views for a tableโ€ฆ

How about the ability to create Dashboard views with, potentially, multiple views on a single page linked to different tables/views in the base. It would be quite normal for a dashboard to provide data from more than one table and so I would prefer these visualisations to be available outside the normal table based menu structure.

If it can only be done as a view associated with a table that would be a huge step from where we are though!

Craig_Cameron
4 - Data Explorer
4 - Data Explorer

Graphs a definite bonus. Why should it be necessary to export data into a spreadsheet just to create a graph?