Top 5 categories, rolling sum every two weeks

[Maya_Hajj_Hasan]

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?

[Adam_Minich · Accepted solution]

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

[Maya_Hajj_Hasan]

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