Skip to content

Reports Constructor

Report Constructor

Report Constructor builds a pivot-style report (a table that summarizes data). You choose what goes across the top (X Axis), what goes down the left side (Y Axes), and what number to show in each cell (Formula). Then you can limit the data using Filters.

⚠️ Only one Formula can be selected at a time.

Steps

  1. Open the platform and login as a School Admin.
  2. Go to “Reports” and select “Constructor”.
  3. In “Report Configuration”, set:
    • “X Axis (Rows)” (columns across the top).
    • “Y Axes (Row Groups)” (rows down the left side).
    • “Formula” (the value shown in each cell).
  4. In “Filters”, select the date range and any other limits you need.
  5. Click “Generate”.
  6. To download the report, click “Export”.

Understanding X Axis, Y Axes, Formula, and Filters

X Axis (Rows)
- This becomes the columns across the top of the table.
- If you choose a date (for example “Attendance Date”), each date becomes a column.

Y Axes (Row Groups)
- These become the rows down the left side of the table.
- You can select more than one Y Axis to group rows (for example by “Section / Subsection”, then by “User”).

Formula
- This is the single value the report calculates for each cell.
- Example: “Total Student Attendance” shows how many attendance records exist for that row and column.

Filters
- Filters limit which records are included in the report.
- Date filters are the most important (for example “Attendance Date” range).

Steps

  1. Decide what you want to compare over time (usually a date) and select it in “X Axis (Rows)”.
  2. Decide who or what you want to list on the left (for example students, sections, attendance types) and tick them in “Y Axes (Row Groups)”.
  3. Select the one Formula that matches your request.
  4. Set the correct date range filter for the data you are using (attendance, grades, assignments, enrolments).
  5. Click “Generate” and review the results.

How to Read the Result Table

  • Top row: your X Axis values (often dates).
  • Left side: your Y Axes grouping (for example “User”).
  • Each cell: the Formula result for that row and column.
  • “Total” column: the overall value for each row across all columns.
  • Bottom “Total” row: the overall value for each column across all rows.

If a cell is empty or zero, it usually means there were no matching records for that combination of row, column, and filters.

Steps

  1. Check that the column headers match your selected “X Axis (Rows)”.
  2. Check that the row labels match your selected “Y Axes (Row Groups)”.
  3. If results look wrong, first check Filters (especially the date range).

Formulas

Each report shows exactly one Formula at a time.

Formula: Average Student Attendance (%)

Shows how often students were present, as a percentage, within the selected filters.
Example: If the result is 80%, it means “present most of the time” during that period and selection.

Good for
- Understanding attendance quality (not just how many records exist).
- Comparing attendance between students, sectiones, or attendance types.

Steps

  1. Set “X Axis (Rows)” to “Attendance Date”.
  2. In “Y Axes (Row Groups)”, tick:
    • “User” (to see each student).
    • Optional: “Section / Subsection” (to group by section).
  3. Set “Formula” to “Average Student Attendance (%)”.
  4. In “Filters”, set the “Attendance Date” range.
  5. Optional: In “Filters”, select “Attendance Types” (if you want to include only certain attendance types).
  6. Click “Generate”.

Formula: Total Student Attendance

Shows how many attendance entries exist in the selected data set.
Example: If the result is 10, it means “10 attendance entries were recorded” for that row and column.

Good for
- Checking if attendance was recorded on specific days.
- Counting attendance activity volume by student, section, or attendance type.

Steps

  1. Set “X Axis (Rows)” to “Attendance Date”.
  2. In “Y Axes (Row Groups)”, tick:
    • “User” (to count per student).
    • Optional: “Attendance Type” (to split counts by type).
    • Optional: “Section / Subsection” (to group by section).
  3. Set “Formula” to “Total Student Attendance”.
  4. In “Filters”, set the “Attendance Date” range.
  5. Click “Generate”.

Formula: Unique Users Count

Shows how many different students/users are included (unique people), not how many records exist.
Example: If one student appears 20 times, they still count as 1 unique user.

Good for
- Seeing how many students were involved in attendance, grades, assignments, or enrolments during a period.
- Comparing participation across roles, terms, programs, or sections.

Steps

  1. Set “X Axis (Rows)” to the timeline you want to compare (for example “Attendance Date”, “Grade Date”, “Assignment Date”, or “Date Joined Workspace”).
  2. In “Y Axes (Row Groups)”, tick the grouping you want (for example “Section / Subsection”, “Role”, “Term”, or “School”).
  3. Set “Formula” to “Unique Users Count”.
  4. Set the matching date filter range (for example “Attendance Date” range if your X Axis is “Attendance Date”).
  5. Click “Generate”.

Formula: Average Grade

Shows the “typical grade” (average) for the selected filters and period.
Example: If the result is 8, it means “the average grade is 8” within that selection.

Good for
- Watching grade changes over time.
- Comparing performance across terms, section, or students.

Steps

  1. Set “X Axis (Rows)” to “Grade Date”.
  2. In “Y Axes (Row Groups)”, tick:
    • “User” (to see each student).
    • Optional: “Term” (to group by term).
    • Optional: “Section / Subsection” (to group by section).
  3. Set “Formula” to “Average Grade”.
  4. In “Filters”, set the “Grade Date” range.
  5. Click “Generate”.

Formula: Total Assignments Completed

Shows how many completed assignments exist in the selected data range.
Example: If the result is 5, it means “5 assignments were completed” for that row and column.

Good for
- Tracking completed work over time.
- Comparing assignment completion between students or sections.

Steps

  1. Set “X Axis (Rows)” to “Assignment Date”.
  2. In “Y Axes (Row Groups)”, tick:
    • “User” (to see each student).
    • Optional: “Section / Subsection” (to group by section).
  3. Set “Formula” to “Total Assignments Completed”.
  4. In “Filters”, set the “Assignment Date” range.
  5. Optional: In “Filters”, select “Students” or “Section / Subsection” to focus the report.
  6. Click “Generate”.

Formula: Total Enrolments

Shows how many enrolment entries exist for programs/sessions within the selected period and filters.
Example: If the result is 12, it means “12 enrolments were recorded” in that selection.

Good for
- Understanding enrolment volume for after-school programs.
- Comparing enrolments by program, session, school chapter, or application status.

Steps

  1. Set “X Axis (Rows)” to the time dimension you use for enrolment analysis (for example “Enrolment Date” if available).
  2. In “Y Axes (Row Groups)”, tick:
    • “Enrolment Program” (to group by program).
    • Optional: “Enrolment Session” (to split by session).
    • Optional: “School Chapter” (to split by location).
    • Optional: “Application Status” (to split by status).
  3. Set “Formula” to “Total Enrolments”.
  4. In “Filters”, set the “Enrolment Date” range.
  5. Optional: Set “Enrolment Programs”, “Enrolment Sessions”, or “Enrolment School Chapters” filters to narrow the report.
  6. Click “Generate”.

Common “I Just Want…” Setups

Daily attendance percentage for each student
- X Axis (Rows): Attendance Date
- Y Axes: User
- Formula: Average Student Attendance (%)
- Filters: Attendance Date range

Attendance counts by type for each day
- X Axis (Rows): Attendance Date
- Y Axes: Attendance Type
- Formula: Total Student Attendance
- Filters: Attendance Date range

Grades over time for one student
- X Axis (Rows): Grade Date
- Y Axes: User
- Formula: Average Grade
- Filters: Grade Date range, Students (select one)

Assignments completed over time for a section
- X Axis (Rows): Assignment Date
- Y Axes: Section / Subsection
- Formula: Total Assignments Completed
- Filters: Assignment Date range, Section / Subsection (select one)

Enrolments by program and session
- X Axis (Rows): Enrolment Date
- Y Axes: Enrolment Program, Enrolment Session
- Formula: Total Enrolments
- Filters: Enrolment Date range

Steps

  1. Pick one setup above that matches your goal.
  2. Apply it in “Report Configuration” and “Filters”.
  3. Click “Generate”.
  4. If you need the data outside the platform, click “Export”.