Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Reports & analytics/Lesson 2

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

    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.

    Open /reports/newRecording script
    12 min9 stepsOwner, Admin, Principal, Accountant, TeacherDemo: sign in as Owner

    Before you start

    Finish first: The report library: built-in reports, your reports, pinned reports

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

    Steps

    0 of 9 done
    1. You should see: 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.

      Open /reports/new
    2. You should see: The columns list and the preview reset to the dataset's default columns. The description under the step title explains what one row means.

      Changing the dataset clears your columns, filters and grouping, so pick it first.

    3. You should see: The preview table shows exactly the ticked columns in that order. Columns marked (id) are hidden identifiers used for filtering.

    4. You should see: The preview shrinks to matching rows; No rows match. Loosen the filters. appears if nothing matches. All conditions must match (AND).

      Up to 20 filters. Remove one with the ✕ button on its row.

    5. You should see: 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.

    6. You should see: A chart appears above the preview table. With y left automatic the chart counts rows.

    7. You should see: The preview footer shows the row count and the page, for example 1,240 rows · page 1 of 25.

    8. You should see: 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).

      Owners, admins and principals always see every saved report whatever its visibility.

    9. You should see: The builder loads with the saved definition; after saving you return to the report page.

      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.

    What you have now

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

    If something goes wrong

    Toast "Could not save" with a field error under Name
    The name is required (up to 120 characters). Fill it in and save again.
    "You do not have access to this dataset."
    You switched to a dataset your role may not read (datasets are filtered per role, but an old link or a copied definition may reference one). Pick a dataset from the list.
    The preview shows a red error instead of rows
    The definition is invalid (for example a filter on a column that no longer exists). Remove the filter and try again.
    A teacher sees fewer rows than expected
    Teachers' reports are limited to their own sections; the report page shows a Your sections only badge.

    Related guides

    • Run a report: run-time filters, CSV download, copy a built-in report, delete
    • Email a report automatically: schedules, Send now and the run log
    The report library: built-in reports, your reports, pinned reportsNext: Run a report: run-time filters, CSV download, copy a built-in report, delete