Qliksense Stdev calculation

[krmvacar]

Hi all,

ı have a one table and two dimensions one measures.

My calculation Avg total time :

AVG(TOTAL<Prodnumber> AGGR(Sum([totaltıme])/count(DISTINCT ordernumber),Prodnumber))

its workıng. 

And ı want to calculation last column stndev.

Stndev must be calculation 

AVG(TOTAL<Prodnumber> AGGR(Sum([totaltıme])/count(DISTINCT ordernumber),Prodnumber))

+

stndev(totaltıme)*1.5

but ıst not workıng:(

Can you help me please?

Best regards,

Prodnumber	ordernumber	Avg total time	stndev
402000076	20112582	78,5	79,325
402000076	20112583	78,5	79,325
402000076	20112584	78,5	79,325
402000076	20112585	78,5	79,325
402000076	20112586	78,5	79,325
402000076	20112587	78,5	79,325
401000180	20062180	227,6	338,255
401000180	20071014	227,6	338,255
401000180	20080483	227,6	338,255
401000180	20090291	227,6	338,255
401000180	20091306	227,6	338,255
401000180	20102272	227,6	338,255
401000180	20102273	227,6	338,255
401000180	20102274	227,6	338,255
401000180	21012073	227,6	338,255
401000180	21022049	227,6	338,255
401000180	21022051	227,6	338,255
401000180	21022915	227,6	338,255
401000180	21022916	227,6	338,255
401000180	21072201	227,6	338,255
401000180	21072954	227,6	338,255
401000180	21080772	227,6	338,255
401000045	20120967	46,4	71,285
401000045	21010464	46,4	71,285
401000045	21050225	46,4	71,285
401000045	21051578	46,4	71,285
401000045	21060094	46,4	71,285
401000045	21060580	46,4	71,285
401000045	21070020	46,4	71,285
401000045	21092422	46,4	71,285
401000045	21092425	46,4	71,285
401000045	21092426	46,4	71,285
401000045	21101558	46,4	71,285
401000045	21111325	46,4	71,285
401000045	21111570	46,4	71,285
401000045	21111571	46,4	71,285

[mato32188]

Hi @krmvacar,

it is actually quite hard to find an answer as we miss the raw data from which you calculate KPIs.

My suggestion is to use the same principle you used to calculate avg, i.e.

STDEV(TOTAL<Prodnumber> [totaltıme]) 

Hope it can help.

m

[krmvacar]

Hi @mato32188

Thank you for answer.I want to show straight table measure.like red column

Best regards

[MarcoWedel]

Did you try if maybe

Avg(TOTAL<Prodnumber> totaltime)

instead of

AVG(TOTAL<Prodnumber> AGGR(Sum(totaltime)/count(DISTINCT ordernumber),Prodnumber))

is sufficient to calculate the average?