Average Jobs Per Day Filtering Issue

Thu, 27 Nov 2014 01:02:53 GMT

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

Re: Average Jobs Per Day Filtering Issue

jagan — Thu, 27 Nov 2014 02:39:24 GMT

Hi,

Try this expression

Avg({$<[Job Type]='CSE'>} Aggr( Count({$<[Job Type]='CSE'>} DISTINCT NotifNo), NotifDateKey) )

Hope this helps you.

Regards,

jagan.