9 shots · about 1 min 55 s of finished video · lesson 2 of Reports & analytics
Record as
Owner (demo_owner)
Sign in at /demo on a demo-mode build
Screens
/reports/new /reports/[id] /reports/[id]/edit
Length
1 min 55 s
narration at ~150 words/min + screen time
Status
Not yet recorded
Before recording
Use the seven-step builder to create a report over any of the twenty datasets, preview it live and save it for yourself or for other staff.
| # | Screen | Action (on screen) | Must be visible | Voice-over | ~s |
|---|---|---|---|---|---|
| 1 | /reports/new | On Reports click New report. | The page New report with numbered cards: 1 Dataset, 2 Columns, 3 Filters, 4 Group & summarise, 5 Sort & chart on the left and 6 Preview, 7 Save on the right. | The builder is a form in seven steps. The preview on the right refreshes as you change anything on the left. | 12 |
| 2 | /reports/new | In 1 Dataset, choose a Data source, for example Fee invoices under the Fees group. Callout: Changing the dataset clears your columns, filters and grouping, so pick it first. | The columns list and the preview reset to the dataset's default columns. The description under the step title explains what one row means. | Twenty datasets are available, grouped as Students, Attendance, Fees, Exams, Staff & HR, Library, Transport, Hostel and more. Each one is a fixed, safe query. | 14 |
| 3 | /reports/new | In 2 Columns, tick the columns you want and use the ‹ and › buttons under Column order to arrange them. | The preview table shows exactly the ticked columns in that order. Columns marked (id) are hidden identifiers used for filtering. | Only the columns you tick appear in the result, so the report shows exactly what the reader needs and nothing more. | 12 |
| 4 | /reports/new | In 3 Filters, click Add filter. Pick a column, a condition (is, is not, is any of, contains, between, on or after / ≥, on or before / ≤, is in period, is empty, is not empty) and a value. For a date column choose is in period and a preset such as This month or This academic year. Callout: Up to 20 filters. Remove one with the ✕ button on its row. | The preview shrinks to matching rows; No rows match. Loosen the filters. appears if nothing matches. All conditions must match (AND). | Date presets are the trick for reports that stay useful: 'this month' is worked out every time the report runs, so a scheduled email is always current. | 15 |
| 5 | /reports/new | In 4 Group & summarise, pick a column from + Group by… (up to 4) and add Summaries: Count of rows, or Sum, Average, Minimum, Maximum of a number column, with an optional label. | The preview turns into one line per group with the summary columns. Step 2 shows the note Grouping is on, so the result shows the group and summary columns instead of these. | Grouping turns a long list into a summary: outstanding fees per class, receipts per payment mode, students per category. | 12 |
| 6 | /reports/new | In 5 Sort & chart, choose Sort by and Ascending/Descending, then a Chart: Table only, Bar, Line or Pie. For a chart choose Chart labels (x) and Chart values (y) or leave them Automatic. | A chart appears above the preview table. With y left automatic the chart counts rows. | A chart makes the summary easier to read in a meeting. Table only is fine when you just want the numbers. | 12 |
| 7 | /reports/new | Check 6 Preview: use Previous / Next when there are more rows than one page. If you see The dataset hit the 5,000-row limit. Add a date filter to narrow it., add a date filter. | The preview footer shows the row count and the page, for example 1,240 rows · page 1 of 25. | Every dataset stops at five thousand rows per run to keep reports fast. A date filter is the usual fix. | 12 |
| 8 | /reports/[id] | In 7 Save, type a Name (for example Class 10 fee defaulters), an optional Description, choose Who can see it: Only me, Selected roles (tick owner, admin, principal, accountant, teacher) or All report users, tick Pin to the reports library if you like, then click Save report. Callout: Owners, admins and principals always see every saved report whatever its visibility. | A toast Report saved and the report opens on its own page. It now appears under My reports (and in others' Shared with me if shared). | Saving gives the report a name and an audience. Keep it private while you are still experimenting, then share it when it is right. | 14 |
| 9 | /reports/[id]/edit | To change a report later, open it and click Edit, adjust any step and click Save changes. Callout: Only the report's owner or an owner/admin can edit it. Others see You can't edit this report with the hint to use run-time filters instead. | The builder loads with the saved definition; after saving you return to the report page. | You can come back and refine a report any time; everyone who opens it afterwards gets the new version. | 12 |
After the video is published
Add its YouTube id under reports-build-custom in src/lib/help/videos.ts, with a chapters map of step number → seconds. The lesson page then shows the video and a “Watch this step” link on every step. See the video production guide.