Counting but not merging duplicates


#1

I am in the process of changing everything from excel/sheets over to Airtable and I have run into a strange problem that is quite trivial in Excel/Sheets but seemingly difficult in Airtable.

Essentially all I want to do is count how many times an email address has come up in the last 30 days from a DATETIME.

Each record has a unique datetime and an email address, all I’m trying to do is count how many times that is happening in Airtable.

The function in sheets is =COUNTIFS(A:A,A2919,B:B,">="B2919-30,B:B,"<="B2919))

Where A is the email column, and B is the date of entry.

Any help would be appreciated.


#2

You might be able to use the summary bar for your needs.

I’d create a new view where records are grouped by the email field (Field A). Field B remains your date field. Then create a formula field (Field C) where the formula is something like DATETIME_DIFF({Field B},TODAY(),'days').

Create a filter for this view: Where {Field C} ≥ [-30] AND Where {Field C} ≤ [0]

The summary bar will count how many times the email was used in the last 30 days.