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


#8

I would like this too. Maybe this could be a view?


#9

I’d love to see the ability to make a timeline as my project is to make a timeline of a trip with photos at each location.


#10

I’d like this too. Otherwise it means I have duplicate data to get a graph and a table of the data in the graph


#11

I’d like to add the ability to plot a point using x,y coordinates! That would be absolutely fantastic.


#12

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. :smiley:


#13

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


#14

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.


#15

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.


#16

+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.


#17

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.


#18

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…


#19

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 :wink: Keep up the good work!


#20

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!


#21

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


#22

I’ve requested this idea as well :slight_smile:


#23

I use Klipfolio.

I have an entire enterprise dashboard which draws from various data sources. Google, smartsheet, excel feeds, and now airtable. I just linked the tool with AirTable data in 5 minutes. The Airtable API makes this very easy. No problem!

Once your data is in Klipfolio, you build all sorts of charts, graphs, etc. As you can imagine, the more management has views and graphs into their data, the more they can’t live without it.


#24

Can you give a brief explanation of how you accomplished this? Thanks!
Michael


#25

Agreed! Definitely would need charting tools as well, and I’d be happy with Google-type visualizations


#26

Thank you. This is helpful in building a case for subscribing to Klipfolio. I heard about it at a Google Analytics conference back in 2014 and need to convince management the return on investment is there. This helps. :+1:


#27

:+1: for a visualisation / dashboard view.