Help

Count the number of new records per quarter

Topic Labels: Formulas
Solved
Jump to Solution
844 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Allison_Durinke
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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”

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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”