Count the number of new records per quarter

Allison_Durinke · ‎Jan 21, 2022

Hi everyone! Is there a formula to count the number of records were added per quarter/year/month?

I would like to know how many were added in general and how many records were added during a specific period by category.

Kamille_Parks · ‎Jan 21, 2022

I explained how to do this on an episode of the BuiltOnAir Podcast:

You can copy the base shown in the podcast above on the Universe here:

Some changes you may want to make for your own version:

In your case, you may want to use a “Created Time”-type field instead of a regular date field.
You also might want to use multiple Count fields with conditions applied. That way you can have one field for the “Count of Category A” and another field for “Count of Category B”

Kamille_Parks · ‎Jan 21, 2022

I explained how to do this on an episode of the BuiltOnAir Podcast:

You can copy the base shown in the podcast above on the Universe here:

Some changes you may want to make for your own version:

In your case, you may want to use a “Created Time”-type field instead of a regular date field.
You also might want to use multiple Count fields with conditions applied. That way you can have one field for the “Count of Category A” and another field for “Count of Category B”