Skip to main content

How to create a graph showing growth over time in Airtable Interfaces?

  • June 10, 2022
  • 2 replies
  • 282 views
J

I’m trying to create a line graph that shows the growth of the sum total number of records (in this case interactions) over time. So the X-axis would be dates and the Y axis would be a sum total of all the records.

For instance, if there are 5 interactions in Week 1 and then 7 interactions in week 2, the week 1 number would be 5 but the week 2 number should be 12 (5 + 7). If week 3 had 7 more interactions, it should be 19 (12 + 7).

As far as I can tell this is impossible in Airtable interfaces. Does anyone have a similar problem or potential workaround?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hi Jake, here’s an example of what mine looks like, which I think is what you’re looking for:


The idea is to have a linked field in the data table to a Weeks table, and to use an automation to link all the records to a new week record via a two step automation. This means that, if you were to add any historical data into the data table you’d have to manually add all of the week links though

I’ve set it up here for you to check out, and you should be able to view the automation

Let me know if you have any questions!

Adam, Airtable Consultant - thetimesaving.company
ScottWorld
J
A
J
  • Jake_O_Shea
  • Author
  • New Participant
  • June 13, 2022

Hi Jake, here’s an example of what mine looks like, which I think is what you’re looking for:


The idea is to have a linked field in the data table to a Weeks table, and to use an automation to link all the records to a new week record via a two step automation. This means that, if you were to add any historical data into the data table you’d have to manually add all of the week links though

I’ve set it up here for you to check out, and you should be able to view the automation

Let me know if you have any questions!


This is great, thanks Adam!

TheTimeSavingCo
Terms & ConditionsAccessibility statement