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

    Weighted Average +/- 1 standard deviation

      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!