elizab Member

Comments

  • Sure - sorry. 'On/Above' is a number value that represents the percent of students in a school that were performing on or above grade-level at the time of the assessment window. We have three assessment windows every year, so there are 'On/Above' values for every assessment window within every year for each school. So, in…
  • Yes, the two values are in the same dataset - in fact they are the same field/column ('On/Above'). It's just that the school filter doesn't apply to the Network Average card in the dashboard. So in this instance would it be… CASE WHEN 'On/Above'>AVG('On/Above) THEN 'above' ELSE 'Below' END Except, because this beast mode…
  • Thanks - I'm wondering if there's a way to use the Beast Mode Editor to create a comparison model with an output of 'above' / 'below', that could be used as the color rule condition. Is that possible?