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: 
Not applicable

Team average and std deviation

Hi all,

I want to build a table that shows me the following:

Team total case volume

Average case volume per team member

+/- 1 and 2 std deviations of the case volume

TeamTotal Case VolumeNo. Team MembersAvg Case Volume/Member1 Std Deviation2 Std Deviations

The objective is to identify team member performance in relation to the whole.

Any assistance on getting this going would be appreciated!

1 Solution

Accepted Solutions
sunny_talwar

May be like this

Stdev(Aggr(Count(Volume), Employee, Team))

View solution in original post

5 Replies
hector_munoz
Specialist
Specialist

Hi John,

This are some clues:

  • 'Team' field as a dimension.
  • An expression with something like "Sum(Volume)" or "Count(Volume)" for 'Total Case Volume'
  • An expression with something like "Count(DISTINCT Employee)" for 'No. Team Members'
  • An expression with something like "[Total Case Volume] / [No. Team Members]" for 'Avg Case Volume / Members'
  • An expression with something like "Std(Volume)" for '1 Std Deviation'

Regards,
H

sunny_talwar

Would you be able to share some sample data and the output you expect to see from the sample data?

Not applicable
Author

Here are the results after applying Hector's clues.  The Stdev function not working yet: Stdev([Closed Cases])

sunny_talwar

May be like this

Stdev(Aggr(Count(Volume), Employee, Team))

Not applicable
Author

Excellent!  thanks to the both of you for the help!