SIMS - Report Help - Attendance

[tech-man]

Hello all 

I am looking to produce a report in SIMS which will give me an export of attendance data.

 

Specifically, individual students' attendance per day per week 1 and week 2 as they want to see if there is a pattern for a particular day.

 

I am not sure how to do this.

 

Thank you

[robslack]

I think the only way to do this is to pull the attendance mark, date, and am/pm flag and then use excel to work out attendance.  This is a report we use

[tech-man]

Thanks for this - what filter do you apply to the attendance marks?

[robslack]

1 minute ago, tech-man said:

Thanks for this - what filter do you apply to the attendance marks?

Just a date filter we use this with Command Reporter Utility to run every night, Then use power query in excel so it can refresh the data

[tech-man]

Thanks - we are looking to export data to use with Power BI....

[robslack]

Just now, tech-man said:

Thanks - we are looking to export data to use with Power BI....

It is the same really, just my SLT love Excel!!!!, CoPilot is your friend for doing this

[tech-man]

We run a two week timetable - is it possible to add to the report week 1 or 2?

[Marci]

You'd define that on your date table over in PowerBI... then the date of the attendance mark would determine wk1 or 2 from your attendance table's relationship with the date table.

Edited April 20 by Marci