
Re: Weighted Average +/ 1 standard deviation
Gysbert Wassenaar Feb 12, 2016 1:07 PM (in response to Drew Nelson)Perhaps the example you can find here helps: QlikView Control (SPC) Chart

Re: Weighted Average +/ 1 standard deviation
Drew Nelson Feb 12, 2016 4:14 PM (in response to Gysbert Wassenaar )I'm working in Sense, so the expressions mentioned might be similar but the interface sure isn't with that document. Also, my average isn't already aggregated as it is in that example; I'm using Qlik to calculate averages with the expression I listed above.

Re: Weighted Average +/ 1 standard deviation
Gysbert Wassenaar Feb 13, 2016 1:04 AM (in response to Drew Nelson)The expressions will be the same for both Qlik Sense and Qlikview. And in both cases you'll want to use a line chart with one dimension and multiple expressions. So it should work just the same for Qlik Sense. Only the UI to add the expressions/measures differs.
And the average in the example isn't already aggregated. The expression for the Average Proces Time is Avg (ProcessTime). The expression to calculate the standard deviation is Stdev(total aggr(avg(ProcessTime),Hour)).
In your situation I expect you need something like this:
Stdev(total aggr((sum(success) + sum(recovery)) / (sum(total transactions), YourChartDimensionHere ))

