4 Replies Latest reply on Jul 26, 2013 4:23 AM by Jim Wahl

    Identifying results outside a Standard Deviation

    Jessica Marzato

      Hi, I'm trying to identify people based on whether their results fall outside of 1 standard deviation of the worksheet average. Ultimately I would like to change their colour based on whether they are within the range or not.

      I have tried creating a measure using couple of different formulas including IF(avg([TotalHandleTime]) > WINDOW_STDEV(avg([TotalHandleTime] )) OR (avg([TotalHandleTime]) < WINDOW_STDEV(avg([TotalHandleTime] )))) Then "OUT" Else "IN" END

      I Have also tried using just STDEV but it’s not working it keeps showing me everyone is “OUT”

      Any suggestions?