Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Count the number of new records per quarter

Topic Labels: Formulas
Solved
Jump to Solution
367 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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”