Top 5 categories, rolling sum every two weeks

Ask the community Formulas
#1

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?

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

#3

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

1 Like
#4

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.