How can I give out % condition matches after a certain date?

[vwegner]

Hey community,

I'm fairly new to Airtable and I am faced with a task I myself cannot seem to wrap my head around: I created a single-select field that checks for a condition (e.g. did you have lunch today?). It's currently not being used yet because I want to get the reporting straight first.

My problem: I already had records in my base prior to this new select field. What I would like to do is to check from a specific date onward (ie. once the new field is live and ready to use for my base editors) how often this field was selected - meaning how many % of all new records did choose to select this optional field (yes, I had lunch today).

Do you have any ideas how I could set this up?

Thank you so much!

Virginia

[TheTimeSavingCo · Accepted solution]

Hm, try using a formula field to check whether the record's "CREATED_TIME()" value is after the specific date?  You can then filter by that formula field in your reporting system