Hi Everybody,
I have an Airtable table already populated.
There's a field called <<Status>> set as a formula that takes either the value <<OK>> or <<Not OK>>
I want to set an automation that calculates the number of rows with the field Status = <<OK>> for each day.
Ideally, I want the results to be shown like this
DATE Number of OKs
15/01/2024 32
16/01/2024 28
......
Thanks in advance for your help.
Just for information, I am a beginner in Airtable. I'm sure there's a simple way to do this although I'm unaware of it.