Average Jobs Per Day Filtering Issue

[#1]

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

[jagan]

Hi,

Try this expression

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

Hope this helps you.

Regards,

jagan.