Totara Learn Open Discussions

Totara 12: Creating a report that filters out repeated names

 
AkramovaSabrina
Totara 12: Creating a report that filters out repeated names
AkramovaSabrina 发表于 2021年07月14日 Wednesday 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,

标签:
Craig Eves
Re: Totara 12: Creating a report that filters out repeated names
Eves (Totara Support)Craig 发表于 2021年07月15日 Thursday 21:04
小组 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


AkramovaSabrina
Re: Totara 12: Creating a report that filters out repeated names
AkramovaSabrina 发表于 2021年07月21日 Wednesday 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
AngusGeorge 发表于 2021年07月25日 Sunday 16:12
小组 Totara

Hi Sabrina,

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

cheers,

George.