Help

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

Topic Labels: Base design Formulas
Solved
Jump to Solution
170 1
cancel
Showing results for 
Search instead for 
Did you mean: 
vwegner
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

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