3 Replies Latest reply: Feb 13, 2016 1:04 AM by Gysbert Wassenaar RSS

    Weighted Average +/- 1 standard deviation

    Drew Nelson

      Hi All-

       

      So, I want to take my line chart and add a +/- 1 standard deviation range around my weighted average, but have no idea how to express standard deviations. The line chart is a successful transaction average displayed by date for a client (so 2 dimensions, date and client), and my expression for the rate is basically this:

       

      (sum(success) + sum(recovery)) / (sum(total transactions)

       

      I basically want 2 reference lines around my rate: +1 stnd dev and -1 stnd dev. I'd really love to put some fancy green shading in between these lines, but that's a want versus a need... Any ideas folks? Thank you!