Works perfectly, 1 question though the rest of the dashboard has the dates as week month year etc, when I put the same format within the cross table
Date(Date) as Date,
Month(Date(Date)) as Month,
Week(Date(Date)) as Week,
Year(Date(Date)) as Year,
Each date then has a month value as part of the workstatus field ,
I would create another table with the month,week and year dimensions and link it to your attendance table via the date field.
There are several calendar creation examples on this forum.
You could also do this.
Year(date) as year,
Month(date) as month,
Week(date) as week
Resident Attendancetablename order by date: