1. Home
  2. Vision & Power BI
  3. Guide to Attendance figures for Vision/Power BI

Guide to Attendance figures for Vision/Power BI

This guide explains how attendance is calculated between MAT Vision, BI and in Bromcom MIS.

Attendance in Vision

Figures within the Vision Attendance are under Analysis>Dashboard>Attendance.

Under Settings the Cohort is set to All Students (All Students refers to Current (C) and Main Dual Registered Students (M).

You may also want to set the Decimal Precision to 2 DP

Analysis > Breakdown Attendance

From the Filters button under the Data Scope tab select to show Aggregate and ensure the End Date matches the End date from the Attendance Dashboard.

Under the Cohort tab, Current and Main Dual Registered Students are checked by Default.

Important: Enrolment Status Key

  • C = Current Students
  • G = Guest Students
  • L = Leaver Students
  • M = Main Dual Registered Students

Now click the Apply button.

The Aggregate Figure should now match the Attendance Dashboard figure.

Attendance in Power BI

Within Reporting > Power Bi Viewer

From Attendance and Exclusion report you would need to ensure that Enrolment Status is the same as the Enrolment Status you have selected in the Vision Dashboard (Attendance Breakdown).

Click on the Groups tab and on the right of All Pupils it should show the Attendance % as highlighted.

Date Ranges

Please also take note of the attendance date range when comparing Attendance with the Vision Dashboard (Attendance Breakdown).

The Date Range in the App is from the week beginning on both Start and End Dates.

Updated on October 27, 2021

Was this article helpful?

Related Articles

Noticed a Missing Guide?
Can't find the guide you need?
Email Us