Skip to content
Workflow · Finance close · Opening soon

Chronic absenteeism report

Export attendance data from PowerSchool, then upload the file to Mammoth. It calculates each student’s absences against the days they were enrolled, flags students at 10% or more, and groups the results by grade.

Early access opens shortly. Check back soon.

Someone typed

“list students who are chronically absent: missed 10% or more of the school days they were enrolled, by grade”

The agent read it as

List students who are chronically absent: missed 10% or more of the school days they were enrolled, by grade, from PowerSchool attendance export.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    PowerSchool attendance export
    CSV export · 40 rows
  2. Step
    List chronically absent students
    Step 1
  3. Result
    Chronic Absence List
    11 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 11 rows came out.

What you get back

The result of that run, the rows to look at first.

Chronic Absence ListSample data11 rows
Student nameGradeAbsence rate (%)Days absentDays enrolledStudent ID
Adrian Cole611.6869100369
Iris Monroe610770100344
Ethan Vale712.7971100347
Micah Lane714.51069100377
Lena Shaw811873100350
Silas Grant812.7971100371
Caleb Finch913.51074100353
Jordan Fox911.3871100379
Aiden Ross1011.1872100359
Layla Quinn1114.91174100362
Julian King12161275100365
11 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Chronic Absence List workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Chronic Absence List: questions

How do you list chronically absent students by grade?
Export attendance data from PowerSchool, then upload the file to Mammoth. It calculates each student’s absences against the days they were enrolled, flags students at 10% or more, and groups the results by grade.
What export should you use?
Use a PowerSchool attendance export that includes student names or IDs, grade, enrollment dates, and attendance records or absence counts. The file needs enough information to compare missed days with days enrolled.
What happens to students who do not match the rule?
Students who are below the 10% threshold do not appear in the final list. If a row is missing the data needed for the calculation, it cannot be used for the report.
How do you change the rule in words?
Edit the rule to match the cutoff you want. For example, change 10% or more to a different percentage, or change the grouping from grade to another field in the export.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →