topic Re: Team average and std deviation in QlikView

Team average and std deviation

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 09 Mar 2017 20:16:59 GMT

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 — Thu, 09 Mar 2017 20:17:21 GMT

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

Thu, 09 Mar 2017 20:38:09 GMT

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

sunny_talwar — Thu, 09 Mar 2017 20:41:37 GMT

May be like this

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

Thu, 09 Mar 2017 20:55:31 GMT

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