This graph is an alternative to Attendance by Homeroom, Daily Heatmap. This version is for schools with a bigger student population, such that viewing all the homerooms at the same time on one slide would be difficult.


Sample



Question Editor


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"


Settings

Columns

  • AttendanceDateEquivalent

  • GradeLevel

  • 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