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.