# How to display "+23 new users this month"

**URL:** <https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858>\
**Category:** Database\
**Created:** [March 9, 2023, 7:10am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858 "2023-03-09T07:10:47Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Orbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/orbit/32/253365_2.png) [@Orbit](https://forum.bubble.io/u/Orbit)\
**Post date:** [March 9, 2023, 7:10am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/1 "2023-03-09T07:10:47Z")

</div>

How can I go about displaying data like how many users has signed up this month? Do I need any new data fields or can I use created date and count?

Can’t seem to find any info ☹

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [March 9, 2023, 7:49am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/2 "2023-03-09T07:49:16Z")

</div>

You _could_ use ‘created date’ for this…

Just search for User’s who’s created date is later than the start of the current month…

But note: ‘created date’ is NOT the same as the date a User signed up to your app (rather it’s the date that the User was created in the database, which could be up to 3 days before they signed up), so it won’t be completely accurate.

If you need to know when a User signed up to your app you’ll have to have a separate User field to store that date.

Also, be aware, that any privacy rules applied to the User datatype (that prevent it being found in searches) will affect the count - only Users that the current User has permission to ‘find in searches’ will be counted, so bear that in mind.

Another option is to create a datatype for this, with a field of Monthly User count, and update it every time a new User signs up to your app, and reset it each month.

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [March 9, 2023, 7:54am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/3 "2023-03-09T07:54:34Z")

</div>

I tend to just do a current date +days -30 as the ‘month’ in these if it just for general stats.

Saves messing with months.

Also means you can save -7 -30 and -365 as an option set and use them to drive a last week/month/year drop-down.

---

<div class="post-metadata">

**Author:** ![Orbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/orbit/32/253365_2.png) [@Orbit](https://forum.bubble.io/u/Orbit)\
**Post date:** [March 9, 2023, 8:35am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/4 "2023-03-09T08:35:35Z")

</div>

Hmm intresting

> [@adamhholmes](#):
>
> Another option is to create a datatype for this, with a field of Monthly User count, and update it every time a new User signs up to your app, and reset it each month.

Hmm interesting idea! Might look into that! How do I reset it after 30 days?

> [@NigelG](#):
>
> I tend to just do a current date +days -30 as the ‘month’ in these if it just for general stats.
> 
> Saves messing with months.
> 
> Also means you can save -7 -30 and -365 as an option set and use them to drive a last week/month/year drop-down

Do you do that as a condition or how do you go about doing that?

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [March 9, 2023, 8:49am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/5 "2023-03-09T08:49:04Z")

</div>

> [@Orbit](#):
>
> Hmm interesting idea! Might look into that! How do I reset it after 30 days?

Just run a backend workflow to reset the value at the start of each month.

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [March 9, 2023, 9:55am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/6 "2023-03-09T09:55:42Z")

</div>

![image](https://us1.discourse-cdn.com/bubble/original/3X/0/6/061e69eaa20531f78af26b5fd683ae0f0cac6791.png)

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/5/0/5057c4244bafb7a7f4991f466a2b394045e2447d.png)

---

<div class="post-metadata">

**Author:** ![Orbit](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/orbit/32/253365_2.png) [@Orbit](https://forum.bubble.io/u/Orbit)\
**Post date:** [March 9, 2023, 10:02am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/7 "2023-03-09T10:02:00Z")

</div>

![Screenshot 2023-03-09 at 11.01.05](https://us1.discourse-cdn.com/bubble/original/3X/7/e/7e61031e3d6b86aa52da23fd80b7b47fd8477ca6.png)

This is the most i could follow haha, whats the next?

> [@NigelG](#):
>
> ![image](https://us1.discourse-cdn.com/bubble/original/3X/5/0/5057c4244bafb7a7f4991f466a2b394045e2447d.png)

What’s this part?

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [March 9, 2023, 11:47am UTC](https://forum.bubble.io/t/how-to-display-23-new-users-this-month/250858/8 "2023-03-09T11:47:20Z")

</div>

It is an option set.

![image](https://us1.discourse-cdn.com/bubble/original/3X/6/d/6dd24b556edee883214b13a91be9625fd6ac0b73.png)
