Best practice forum (Archived)

Totara 9 : Using aggregation for custom field in report

 
Alexandre Paradis
Totara 9 : Using aggregation for custom field in report
by Alexandre Paradis - Thursday, 10 August 2017, 6:16 AM
 

Hello,

We created a custom field in courses for the estimated duration (text input). We added a regex validation to be sure the value entered is numeric.

We want to aggregate this information in some report to have the total estimated time a user spent on courses. Since we use a text input field, the report builder only show text aggregation functionnality.

Is there a way to tell Totara that a custom field is numeric so we can use numeric aggregation functionnality on a custom field while creating reports?

Regards,


me
Re: Totara 9 : Using aggregation for custom field in report
by George Angus - Monday, 14 August 2017, 4:41 PM
Group Totara

Hi Alexandre

I think the only way to achieve this would be to customise the code. 

regards,

George.