# Count users per month in a dashboard

**URL:** <https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652>\
**Category:** Ask for Help\
**Created:** [December 13, 2023, 8:33am UTC](https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652 "2023-12-13T08:33:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\
**Post date:** [December 13, 2023, 8:33am UTC](https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652/1 "2023-12-13T08:33:56Z")

</div>

Hi guys,

I would like to ask you a question. How could I calculate the number of registered users per month if I have the registration timestamp available?

I have this Dashboard table to manage everything and the timestamp in the Users table:

 ![Dashboard Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b94f090c36990ff8989a8cbe930cdead6a5f194c.png)

 ![Users Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4eaff12e1b3c772decd14b7c5c57c7daab96c69a.png)

Thanks 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 13, 2023, 8:54am UTC](https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652/2 "2023-12-13T08:54:40Z")

</div>

My suggestion:

- In each of the two tables, create a math column that converts the Dates (Month of the Year and Registered Timestamp) to integers in YYYYMM format. Use the following formula:

```auto
Year(Date)*10^2
+Month(Date)

```

- In your Dashboard table, create a multiple relation column that matches the integer date column with the same column in your Users table
- Do a rollup-\>count through that relation

---

<div class="post-metadata">

**Author:** ![Luca\_Dipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luca_dipa/32/67530_2.png) [@Luca\_Dipa](https://community.glideapps.com/u/Luca_Dipa)\
**Post date:** [December 13, 2023, 9:10am UTC](https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652/3 "2023-12-13T09:10:10Z")

</div>

Much easy than I expected!

Thank you Darren for the help!!! 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 20, 2023, 9:10am UTC](https://community.glideapps.com/t/count-users-per-month-in-a-dashboard/68652/4 "2023-12-20T09:10:31Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.