Let Date be your datefield..and Attendence is field with 0 for Absence or 1 for presence
Now while loading..........
--------new aliase field-----------------
Month(Date) as Month
Now you can use month as Dimension...and Expression=sum(Attendence)
Any other issue let me know.
Load the script using the wizard (when you click on the table files button at the bottom of the edit script box it prompts you to open a file and then opens a wizard) go through the process and choose the enable transformation process option. When you get to the File Wizard option view it gives you the option to put your data into a Crosstable - this will help you to put all the dates into one data field.
Hope this helps