Skip to main content
Solved

Top 5 categories, rolling sum every two weeks

  • May 11, 2021
  • 2 replies
  • 18 views

Forum|alt.badge.img

Hey everyone!

I have a database of customer feedback that I’ve compiled and categorized by theme. I’d like to extract the top 5 themes and show them as a bar graph. Additionally, I’d like to have an option to change the week # and the bar graph will adjust the top 5 themes accordingly.

Is this possible on Airtable?

Best answer by Adam_Minich

Hi Maya,

Adam from Airtable here.

To accomplish this you’d likely want to use a combination of linked record and lookup, rollup, and count fields.

I made a short video of the overall idea I had for you here: Screen Recording 2021-05-12...

Hope that helps you gather some ideas~~

2 replies

Adam_Minich
Forum|alt.badge.img+18
  • Employee
  • Answer
  • May 12, 2021

Hi Maya,

Adam from Airtable here.

To accomplish this you’d likely want to use a combination of linked record and lookup, rollup, and count fields.

I made a short video of the overall idea I had for you here: Screen Recording 2021-05-12...

Hope that helps you gather some ideas~~


Forum|alt.badge.img

Hi Maya,

Adam from Airtable here.

To accomplish this you’d likely want to use a combination of linked record and lookup, rollup, and count fields.

I made a short video of the overall idea I had for you here: Screen Recording 2021-05-12...

Hope that helps you gather some ideas~~


Thanks so much Adam! This is great and super helpful.