Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elaiken3
Contributor II
Contributor II

Average number of employees at a certain level per project

I am trying to make a sheet that will display the average number of employees at a certain level per project. The data I have looks like this:

Project IDEmployee IDEmployee Title
10001kdk155Entry
10001sdf166Entry
10001dgr856Entry
10001snf965Mid
10001fot354Mid
10001rrg855Mid-Senior
10001plf556Senior
10002wes749Entry
10002hcv247Entry
10002dod653Entry
10002ydf417Entry
10002cbn852Mid
10002pls745Mid
10002kcq384Mid
10002idj721Mid-Senior
10002rid939Senior
10002mhd454Senior

 

How would I calculate, as a measure, the average count of each Employee Title per Project. I have been getting pretty funky numbers here lately with the formulas I've been using. Any help provided would be much appreciated. Thanks.

Labels (2)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Is this what you are looking for ?

avg.PNG

View solution in original post

2 Replies
Lisa_P
Employee
Employee

Is this what you are looking for ?

avg.PNG

elaiken3
Contributor II
Contributor II
Author

Yes it is generally. It actually worked when I put it like this:

Avg(Aggr(Count([Employee Title]),[Project ID],[Employee ID]))

Thank you!