This page shows how to build three different versions of the same graph. The only difference is the custom formula that is utilized in the green, left-side Summarize. 


Sample Output


Question Editor


Note: YearSequence = -1, 0



Formulas

ISA

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

Chronic AbsenteeismCountIf([Chronicallyabsent] = "True") / Count
TruantCountIf([Truant] = "True") / Count





Visual Settings


Data

X-axis

  • SchoolName

  • SchoolYear
    • Prior SY: Light Blue, 2022
    • Current SY: Dark Blue, 2023

Y-axis

  • ISA

    • Style: Percent

    • Minimum number of decimal places: 0

Display

Stacking: Don’t Stack

Goal Line: Yes  (for Attendance) 

  • Value: [varies by school]

  • Goal label: Goal

Show values on data points: Yes

Axes

X-axis:

  • Show label: No
  • Scale: Ordinal

Y-axis: 

  • Show label: No
  • Auto y-axis range: Yes
  • Scale: Linear



Customizations

Notes on how to customize at different schools