Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to calculate of standard deviation on column Type for every date. But I am not able to use stdev function. It just gives, empty boxes.
Type | Number of days | Date | Count |
---|---|---|---|
CC | 11 | 1-Aug-2012 | 1 |
CC | 16 | 2-Aug-2012 | 1 |
CC | 11 | 3-Aug-2012 | 1 |
CC | 11 | 2-Aug-2012 | 1 |
DD | 11 | 1-Aug-2012 | 1 |
DD | 11 | 1-Aug-2012 | 1 |
DD | 16 | 1-Aug-2012 | 1 |
DD | 16 | 1-Aug-2012 | 1 |
DD | 31 | 2-Aug-2012 | 1 |
DD | 31 | 2-Aug-2012 | 1 |
DD | 31 | 3-Aug-2012 | 1 |
DD | 31 | 3-Aug-2012 | 1 |
EE | 6 | 2-Aug-2012 | 1 |
EE | 6 | 2-Aug-2012 | 1 |
EE | 6 | 2-Aug-2012 | 1 |
EE | 6 | 2-Aug-2012 | 1 |
EE | 6 | 3-Aug-2012 | 1 |
EE | 11 | 3-Aug-2012 | 1 |
EE | 31 | 2-Aug-2012 | 1 |
EE | 31 | 2-Aug-2012 | 1 |
I tried to create table with Type, Number of Days, Date, Sum(Count), stddev(Aggr(Sum(Count),Type,Number of Days).
But stddev function is showing empty values.
Any advice how to make it work?
Thanks in advance for your help.
Hi Andre,
Stddev is a group function ie, needs more than one value for input. In the above expression only one unique value exists for each type and number of days; equivalent of saying stddev(1) and hence no stddev. May be you need to articulate the functional need of stddev for me to help.
Regards,
Kiran.
Hi Kiran, Thanks for response. Let me to take a step back and try to check my requirement again.