Report Builder
The Report Builder lets instructors and admins create custom reports by selecting a data source, choosing fields, applying filters, and configuring visualization options. Reports can be previewed in real-time and saved as reusable templates.
Building a Report
1
Enter report details
Give your report a name and optional description. This helps identify the report in your saved templates list.
2
Select a data source
Choose the data entity to report on — Users, Exams, Exam Attempts, Classes, or Grades. Changing the data source resets field selections and filters.
3
Choose fields
Select which fields to include in the report using checkboxes. By default, the first 4 fields are pre-selected. At least one field must be selected.
4
Apply filters (optional)
Add conditions to narrow your data. Each filter has a field, operator (Equals, Not Equals, Greater Than, Less Than, Contains), and a value.
5
Configure grouping and sorting
Optionally group results by a field and set sort order (ascending or descending).
6
Select visualization type
Choose how to display results: Table, Bar Chart, Line Chart, or Pie Chart.
7
Preview the report
Click Preview to execute the report and see live results. The preview panel shows up to 50 rows of data.
8
Save the template
Click Save Template to store the report configuration. Saved templates appear on the Reports dashboard.
Report Details
| Field | Required | Type | Description |
|---|---|---|---|
Report Name | Required | text | A descriptive name for the report template (e.g., "Monthly Performance Report"). |
Description | Optional | text | Brief explanation of what this report tracks. |
Available Data Sources
Each data source exposes a specific set of fields. Selecting a data source determines which fields are available for the report.
| Field | Required | Type | Description |
|---|---|---|---|
Users | Optional | data source | Fields: name, email, role, status, created date, last login, organization. |
Exams | Optional | data source | Fields: name, subject, status, created date, total questions, instructor name. |
Exam Attempts | Optional | data source | Fields: student name, exam name, score, percentage, status, started at, submitted at, time taken. |
Classes | Optional | data source | Fields: name, grade, section, student count, instructor name, created date. |
Grades | Optional | data source | Fields: student name, exam name, score, grade, date. |
Filter Operators
- Equals — Exact match
- Not Equals — Excludes exact matches
- Greater Than — Numeric comparison
- Less Than — Numeric comparison
- Contains — Partial text match
Visualization Types
- Table — Tabular data with rows and columns. Best for detailed data inspection.
- Bar Chart — Vertical bars for comparing values across categories.
- Line Chart — Trend lines for time-series data.
- Pie Chart — Proportional breakdowns for categorical data.