Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Top 5 categories, rolling sum every two weeks

Topic Labels: Formulas
Solved
Jump to Solution
278 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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~~

See Solution in Thread

2 Replies 2

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.