Best practice forum (Archived)

Reporting Question

I'm hoping I've simply missed something...

Many of our required reports are by Individual Staff member (row, appearing only once, and with almost all available profile data) and then columns of grade/competion in courses already set in the report (say, all Health & Safety, all ethics, and Induction).

I've tried different report builder sources, and external to report builder, using the grade publishing option from the course page into the mother of all Excel spreadsheets.

Surely, there's a better way. Any ideas?

Cheers
Austen

Permalink | Reply

Hi Austen

It sounds as though you are talking about the ability to create grouping in the report builder if the group is not already defined in the report source.

Currently grouping is possible in the report source eg Course completion by organisation but you can't change the grouping using the report builder interface.

The closest report source in Totara is probably Record of Learning Courses that has user and course grade info in it.

Excel does grouping pretty well using pivot tables. You could group with multiple levels eg user, category, enrolment date, grade etc . Excel is capable of analysing hundreds of thousands of rows rapidly and also create charts so your large spreadsheet shouldn't pose too many problems.

More report data sources are being created, it sounds like this one might be a good candidate.

Craig

Permalink | Show parent | Reply