Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating an expression that shows the average number of jobs that an employee does per day.
My expression: Avg({$<[Job Type]='CSE'>} Aggr( Count(DISTINCT NotifNo), NotifDateKey) )
This expression works on an indiviual level:
However, when i don't filter for individuals, the expression doesn't work.
How do I change my expression so that it only averages that individuals jobs rather than looking at the entire data set for each employee.
Any help would be gretaly appreciated.
Matt
Hi,
Try this expression
Avg({$<[Job Type]='CSE'>} Aggr( Count({$<[Job Type]='CSE'>} DISTINCT NotifNo), NotifDateKey) )
Hope this helps you.
Regards,
jagan.