I managed to get the matrix (that I think I need).
I suspect I'm making this more complicated than I need to, but here's the load script I'm using...
//get list of all dates
distinct "Beginning Date" as DateList,
where exists ("Beginning Date")
// get list of all Facilities
distinct "Facility" as FacilityList,
//Make an aggregate Key of all Date and Facility combinations
DateList&FacilityList as KeyDATEFAC,
drop table ReportListTemp;
My script is as follows, but if yours works also, than its ok .
Load * Inline
Date as DateT,
count(Facility) as CountFac // Counts the reports
Group by Facility,Date;