# קבל ספירת חברים כוללת לפי חודש באמצעות Data Explorer

**URL:** <https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [8 בפברואר,‏ 2021,‏ 2:29pm UTC](https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899 "2021-02-08T14:29:43Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
**Post date:** [9 בפברואר,‏ 2021,‏ 9:56pm UTC](https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899/4 "2021-02-09T21:56:37Z")

</div>

I guess you mean something like this?

```sql
select date_part('year', created_at) as year, 
date_part('month', created_at) as month,
count(*) as "count"
from users
group by date_part('year', created_at), date_part('month', created_at)
order by date_part('year', created_at) asc,
 date_part('month', created_at)

```

---

_[View the full topic](https://meta.discourse.org/t/get-member-count-overall-by-month-using-data-explorer/178899)._
