The best report to use for this is the Day of The Week Analysis Report.
Please refer to:
This allows you to choose just 1 absence code or all of them and shows how many of each code has been used for each student for Monday to Friday.
You can click on the absence codes in here to expand it and show more data.