[bromcom] Anyone creating reports based on I01 & I02 attendance codes

[CyBeRkId2002]

Hi all,

 

Our attendance officer has been asked to crunch some numbers on what our attendance figures look like excluding I02 (presumably to see what impact COVID is having etc., where we would be under normal circumstances etc.). This has naturally come my way!

 

I am trying to do this in Bromcom, but struggling. The Attendance (Basic) has been updated but does not include the ability to export the attendance mark unique key - so can't incorporate this with our existing PowerBI analysis. The PowerBI feed is yet to include attendance sub-code.

 

Anyone else have any ideas on how I can easily do this (without re-writing ALL of our dashboards based around the Attendance (Basic) report)?

[SpreadsheetJockey]

Could you make a custom unique key in power query out of the available data e.g. studentid&date&period (or whatever) in both your current data and the subcode report data and use that to link them up in the schema?

[CyBeRkId2002]

Thanks for this... As far as I am aware even the above is not always unique as you can have more than one attendance mark for a date and period (if a teacher updates the code for example during the lesson).

 

I have added a development suggestion to Bromcom so hopefully this will be added soon. As it stands I cannot think of a way which is going to be 100% reliable with no chance of misrepresenting the data.

[SpreadsheetJockey]

I vaguely recall you can group data to only show the most recent entry, which might solve the problem you mention (with a bit of faffing around). However, Bromcom does need to update their feeds, especially the non-Vision odata feed which is hugely behind the Vision one in terms of added functionality and information. Nothing has been changed in the regular feed for at least a year - I assume because they are trying to sell Vision to everyone.

[park_bench]

Good morning,

 

If you have access to MAT Vision, there are various OData endpoints that could be useful, including:

• SessionAttendanceCodesByYear, SessionAttendanceCodesByMonth, SessionAttendanceCodesByWeek - These all summarise the count of attendance codes/subcodes in a period by student
  
• SessionAttendances - This returns all raw data from the Vision attendance table (including subcode) for the past 7 days
  
• SessionAttendanceYTD - This is a live endpoint (not using data stored in MAT Vision) that connects to all MIS DBs linked to Vision and returns all AM/PM marks in the year-to-date, including subcodes and mark meaning
  

 

If you don't have access to Vision, you could create a Quick Report to find the Attendance Mark count in a date interval (year-to-date) per student. You could then make this report into a Live Feed for use in your PowerBI report.

 

I realise that this probably means you will have to redevelop your Power BI reports, but hope it may be useful information.

 

Ben