{"title":"Year on Year Persistent Absentee percentage % report","exportedDatetime":"2023-03-15 15:32:27","report":{"reportClass":"Student_Report_EnrolledStudents","title":"Year on Year Persistent Absentee percentage % report","scopes":[{"baseEntityType":1,"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1},"filters":[]}],"groupings":[{"fieldClass":"AcademicLevel_Field_ByStudent","fieldParams":{"referenceDateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self"}],"postGroupingFilters":[],"columns":[{"fieldClass":"Field_GroupingElementLabel","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"GROUP_MODELS","targetIndex":0,"customLabel":null,"formatterClass":"Field_Formatter_Base","identifier":"column2366","summaryRowFormulaClass":null,"conditionalFormatters":[]},{"fieldClass":"Field_GroupingElementSize","fieldParams":[],"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Number of students this year","formatterClass":"Field_Formatter_Numeric_0dp","identifier":"column2372","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"startDate":"2018-09-01","endDate":"2019-08-31"}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"2018\/2019","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2369","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"startDate":"2019-09-01","endDate":"2020-07-31"}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"2019\/2020","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2370","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"startDate":"2020-09-01","endDate":"2021-08-31"}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"2020\/2021","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2520","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"startDate":"2021-09-01","endDate":"2022-08-31"}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"2021\/2022","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2521","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"startDate":"2022-09-01","endDate":"2023-08-31"}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"2022\/2023","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2522","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":-1,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Last year","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2524","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"StudentAttendance_RollCallField_PersistentAbsentee","fieldParams":{"persistentAbsenteeThreshold":"10","dateRange":{"periodType":"ACADEMIC_YEAR","periodOffset":0,"periodCount":1}},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"This year","formatterClass":"Field_Formatter_Statistic_FormattedValue","identifier":"column2523","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]},{"fieldClass":"Field_AdvancedCalculation","fieldParams":{"dataType":"float","formula":"{{ column2523 }}-{{ column2524 }}"},"transformationClass":"Report_Transformation_Self","targetType":"BASE_MODELS","targetIndex":null,"customLabel":"Difference between last year and this year","formatterClass":"Field_Formatter_Numeric_2dp","identifier":"column2525","summaryRowFormulaClass":"Report_SummaryRow_Formula_Average","conditionalFormatters":[]}],"orderings":[{"fieldClass":"Student_Field_Name","fieldParams":[],"direction":"ASC","targetType":"BASE_MODELS","targetIndex":null,"transformationClass":"Report_Transformation_Self"}],"collations":[]}}