This article explains how to add a logic filter to the Demerits column in Student Scoreboards. In the example shown, a filter is being set to see all students in the school that have less than 40 demerits (Year to Date) for a school-wide field trip.
To begin, click on Insights in Menu or visit insights.liveschoolinc.com
After hitting Save, Student Scoreboards will only display students with less than 40 demerits. If you ever need to turn off the logic: