Totara Learn Open Discussions

Totara 12: Creating a report that filters out repeated names

 
Sabrina Akramova
Totara 12: Creating a report that filters out repeated names
di Sabrina Akramova - Wednesday, 14 July 2021, 07:49
 

Hello, 


Looking for an answer to see if there's a way to pull/create a Course Completion report of where I can have no repeated names whether that's of employee names or manager name with information-

How many employees (sum) per manager have overdue training (regardless of how many courses) overall?

With columns-

Manager Name || Number of Employees with overdue training.


V/r,

Tag:
Craig Eves
Re: Totara 12: Creating a report that filters out repeated names
di Craig Eves (Totara Support) - Thursday, 15 July 2021, 21:04
Gruppo Totara

Hi Sabrina

It is possible to use aggregation for the user name column and count only unique names.

There are a few examples of the aggregated reports here. 

Regards


Sabrina Akramova
Re: Totara 12: Creating a report that filters out repeated names
di Sabrina Akramova - Wednesday, 21 July 2021, 11:44
 

Thanks, 


Which source/report type is best to implement? So far sounds like program completion since programs have the due dates.


Thanks!

me
Re: Totara 12: Creating a report that filters out repeated names
di George Angus - Sunday, 25 July 2021, 16:12
Gruppo Totara

Hi Sabrina,

Program Overview would probably be the way to go, it provides for greater flexibility when reporting on Course completion.

cheers,

George.