Hi 👋 I'm not an expert with formulas, but I think I'm overthinking this / making it more complicated than it needs to be.
I have a CSAT (customer satisfaction score) form in Typeform that is being automatically sent to Airtable. What I'm trying to do is:
- a) calculate the CSAT score (# of 4/5 star ratings, divided by # of total responses, multiplied by 100)
- b) have it calculated every calendar week (so there should be a new rating every Monday)
I can do this manually for now, but I want a way that each week, people can look and see what the score is, without anyone having to manually calculate it.
I'm totally lost, although I think I am overthinking this. Any ideas? 😅
I've attached screenshots of the set-up currently.
- We have two sources for the feedback form, so there's one table for each of those.
- Then I have the 'Score' table, which has 5 records, one for each rating (1-5 stars), plus another one for 'TOTAL' which I added in my efforts to calculate the score (it can be deleted if not needed).
- There's a fifth table for tagged feedback but I don't think that's relevant right now.
EDIT: would it make more sense to run a script once per week? 🤔 🤔