Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Top 5 categories, rolling sum every two weeks

Topic Labels: Formulas
Solved
Jump to Solution
1035 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Maya_Hajj_Hasan
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Adam_Minich
Airtable Employee
Airtable Employee

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
Adam_Minich
Airtable Employee
Airtable Employee

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.