# Dashboard Rapport - Aanmeldingen

**URL:** https://meta.discourse.org/t/dashboard-report-signups/288037
**Category:** Data & reporting
**Tags:** sql-query, dashboard-reports, dashboard-sql
**Created:** [8 december 2023 om 23:39 UTC](https://meta.discourse.org/t/dashboard-report-signups/288037 "2023-12-08T23:39:47Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![SaraDev](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/saradev/32/335139_2.png) [@SaraDev](https://meta.discourse.org/u/SaraDev)
#### Post date: [8 december 2023 om 23:39 UTC](https://meta.discourse.org/t/dashboard-report-signups/288037/1 "2023-12-08T23:39:47Z")

</div>

This is an SQL version of the Admin Dashboard Report for Signups.

The SQL report will count the number of users who have joined a forum each day between two dates, `:start_date` and `:end_date`, which are parameters that can be adjusted according to the reporting needs.

```sql
-- [params]
-- date :start_date
-- date :end_date

SELECT
    u.created_at::date AS Day,
    Count (id) 
FROM users u
WHERE
    u.created_at::date BETWEEN :start_date::date AND :end_date::date
GROUP BY u.created_at::date

```

### Example Results

| day | count |
| --- | --- |
| 2023-01-01 | 12 |
| 2023-01-02 | 13 |
| 2023-01-03 | 17 |
| 2023-01-04 | 30 |
| 2023-01-05 | 12 |
| 2023-01-06 | 5 |
| 2023-01-07 | 9 |

---

<div class="post-metadata">

### Author: ![marakagi](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/marakagi/32/281872_2.png) [@marakagi](https://meta.discourse.org/u/marakagi)
#### Post date: [24 december 2024 om 18:18 UTC](https://meta.discourse.org/t/dashboard-report-signups/288037/2 "2024-12-24T18:18:54Z")

</div>

Perfect! Thank you so much.