Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Reports & analytics/Build a custom report: dataset, columns, filters, grouping, chart/Script

    Recording script: Build a custom report: dataset, columns, filters, grouping, chart

    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

    • Seeded data for the dataset you pick (students, invoices, attendance and so on).

    Intro voice-over

    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.

    #ScreenAction (on screen)Must be visibleVoice-over~s
    1/reports/newOn 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/newIn 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/newIn 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/newIn 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/newIn 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/newIn 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/newCheck 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]/editTo 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

    Outro voice-over

    • A saved report with its own address that you (and the roles you chose) can open, pin, email and export.

    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.