Sample Output


Question Editor


Custom Columns

EnrolledCheck

=case([Currentlyenrolled] = "true", "https://edops-dash-assets.s3.amazonaws.com/CheckYesPresent.png", [Currentlyenrolled] = "false", "https://edops-dash-assets.s3.amazonaws.com/CheckNo.png")

SPEDCheck

=case([Specialeducation] = "true", "https://edops-dash-assets.s3.amazonaws.com/CheckYesBlue.png", [Specialeducation] = "false", "https://edops-dash-assets.s3.amazonaws.com/CheckNo.png")

ELCheck

=case([Limitedenglishproficiency] = "true", "https://edops-dash-assets.s3.amazonaws.com/CheckYesBlue.png", [Limitedenglishproficiency] = "false", "https://edops-dash-assets.s3.amazonaws.com/CheckNo.png")

TruantCheck

=case([Truant] = "true", "https://edops-dash-assets.s3.amazonaws.com/CheckYesRed.png", [Truant] = "false", "https://edops-dash-assets.s3.amazonaws.com/CheckNo.png")

ChronicCheck

=case([Chronicallyabsent] = "true", "https://edops-dash-assets.s3.amazonaws.com/CheckYesRed.png", [Chronicallyabsent] = "false", "https://edops-dash-assets.s3.amazonaws.com/CheckNo.png")


Visual Settings

Columns

  • EnrolledCheck

    • Rename to Active

    • Display as Image

  • StudentID

    • Rename to SIS ID

    • Separator style: 100000.00

  • StudentName

    • Rename to Student Name

  • GradeLevelStr

    • Rename to Grade Level

  • Gender

  • Homeroom

  • SPEDCheck

    • Rename to SPED (or equivalent)

    • Display as Image

  • ELCheck

    • Rename to LEP (or equivalent)

    • Display as Image

  • Sum of YTDISA

    • Rename to ISA (YTD)

    • Show as mini bar chart

    • Style = percent

  • Sum of AttendanceLast7Days

    • Rename to ISA (LastWk)

    • Show as mini bar chart

    • Style = percent

  • ChronicCheck

    • Rename to Chronic

    • Display as Image

  • Sum of UnexcusedAbsences

    • Rename to Unexcused

    • Show as mini bar chart

  • TruantCheck

    • Rename to Truant

    • Display as Image


Customizations

Notes on how to customize at different schools