# דוח דשבורד - העלאות מובילות

**URL:** https://meta.discourse.org/t/dashboard-report-top-uploads/288440
**Category:** Data & reporting
**Tags:** sql-query, dashboard-reports, dashboard-sql
**Created:** [12 בדצמבר,‏ 2023,‏ 10:57pm UTC](https://meta.discourse.org/t/dashboard-report-top-uploads/288440 "2023-12-12T22:57:25Z")
**Posts on this page:** 1
**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: [12 בדצמבר,‏ 2023,‏ 10:57pm UTC](https://meta.discourse.org/t/dashboard-report-top-uploads/288440/1 "2023-12-12T22:57:25Z")

</div>

This is an SQL version of the Dashboard Report for Top Uploads.

This report provides a detailed list of files uploaded by users within a specific date range. It includes the user ID associated with each upload, the file extension, the size of the file in megabytes, and the original filename.

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

SELECT 
    user_id, 
    extension,
    ROUND((filesize/1048576.00),1)||'MB' AS "File size",
    original_filename Filename
FROM uploads
WHERE created_at::date BETWEEN :start_date AND :end_date
ORDER BY filesize DESC

```

### Parameters

- `:start_date`: The beginning of the date range for the report.
- `:end_date`: The end of the date range for the report.

Both date parameters accept the format of `YYYY-MM-DD` .

### Example Results

| user | extension | File size | filename |
| --- | --- | --- | --- |
| user\_1 | mp4 | 26.8MB | uploadname012345.mp4 |
| user\_2 | mp4 | 26.4MB | example\_mp4name.mp4 |
| user\_3 | mov | 23.3MB | screenrecordingofanerror.mov |
| … | … | … | |