Sample Output



Question Editor (Option #1: Segment Homerooms by Grade Level)


Question Editor (Option #2: Segment Homerooms by Campus)



Formulas

ISA

CountIf([Present] = "True") / Count


Production Notes

  • If this Question was created from an existing graph using the "Duplicate" feature, you will need to change the visualization from "Bar" type to "Table" type. 
  • If this Question was created as a "New Question", change all the Column settings below before selecting "Pivot the table: Yes"


Visual Settings

Columns

  • AttendanceDateEquivalent

  • Homeroom

  • ISA

    • Style: Percent


Pivot the table: Yes 

(Do this step after all the other column settings)

Conditional Formatting

ISA

  • Click "Add a rule"

  • Which columns should be affected: ISA

  • Formatting Style: Color Range 

  • Colors: (Red->White->Green, no Red->Yellow->Green)

  • Start the range at: Custom Decimal (Ex: 0.82) 
        This amount should be set by experimentation

  • End the range at: Custom Value (Ex: 0.90) 
       This amount should match the attendance goal

  • Click "Add rule" button




Customizations

Notes on how to customize at different schools


There are several options if your school has a lot of homerooms

  1. Split by Grade: Create a question for group of grades. 
    1. Add a filter, such as GradeLevel <=4. 
  2. Split by Homeroom initial. Create a question for each range of homeroom initials
    1. Define custom column, HRInitial: =regexextract([Homeroom], "^[A-C]")
    2. Add a filter HRInitial is not empty
    3. Note: This method is used at PAUL, WYY
  3. Ignore homerooms altogether and summarize by grade level
  4.