Team average and std deviation

[#1]

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

Team	Total Case Volume	No. Team Members	Avg Case Volume/Member	1 Std Deviation	2 Std Deviations

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

Any assistance on getting this going would be appreciated!

[hector_munoz]

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?

[#4]

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

[sunny_talwar · Accepted solution]

May be like this

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

[#6]

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